SQLite - Show table's description
How to show table’s description in SQLite?
It’s equivalent to MySQL’s DESCRIBE.
1. Using command line:
Run this command to show the table description:
.schema table_name
2. Using SQL query:
While using query editor, run this query:
PRAGMA table_info(table_name);
3. Using TablePlus
In TablePlus, you can see from the SQLite GUI tool.
- Open to view the table
- Switch to structure view by clicking on the Structure button at the bottom, or use Cmd + Ctrl + ]. You can also right click on the table name on the left sidebar and select Open Structure
- Then you will see a Definition button near the top right.
Need a good GUI Tool for SQLite? Check out TablePlus, the tool of choice for managing relational databases. Native, beautiful, and free.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
