是否有相当于 MySQL 的 DESCRIBE [ table ]的 SQLite？

Question

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?

转载于:https://stackoverflow.com/questions/3330435/is-there-an-sqlite-equivalent-to-mysqls-describe-table

Answer 1

The SQLite command line utility has a .schema TABLENAME command that shows you the create statements.