CodeGuy CodeGuy - 1 year ago 139
iOS Question

SQLite3 terminal

How can I figure out the column names of a table using sqlite3 from the terminal on a mac? I forgot what I named the columns and I can't figure out how what the names were. Thanks!

Answer Source


.schema {tablename}

in the SQLite console will print out the CREATE statement.

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