Matthew Pirocchi Matthew Pirocchi - 1 year ago 263
MySQL Question

Is there an SQLite equivalent to MySQL's DESCRIBE [table]?

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?

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download