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


i'm getting started learning sqlite. nice able see details table, mysql's describe [table]. pragma table_info [table] isn't enough, has basic information (for example, doesn't show if column field of sort or not). sqlite have way this?

the sqlite command line utility has .schema tablename command shows create statements.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -