是否有一个与MySQL的DESCRIBE [表]等效的SQLite? [英] Is there an SQLite equivalent to MySQL's DESCRIBE [table]?
本文介绍了是否有一个与MySQL的DESCRIBE [表]等效的SQLite?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我刚刚开始学习 SQLite .能够查看表的详细信息(如MySQL的DESCRIBE [table]
)将非常好. PRAGMA table_info [table]
不够好,因为它仅具有基本信息(例如,它不显示列是否为某种字段). SQLite有办法做到这一点吗?
I'm just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL's DESCRIBE [table]
. PRAGMA table_info [table]
isn't good enough, as it only has basic information (for example, it doesn't show if a column is a field of some sort or not). Does SQLite have a way to do this?
推荐答案
SQLite命令行实用程序有一个.schema TABLENAME
命令,向您显示create语句.
The SQLite command line utility has a .schema TABLENAME
command that shows you the create statements.
这篇关于是否有一个与MySQL的DESCRIBE [表]等效的SQLite?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文