Created
June 17, 2016 06:45
-
-
Save appkr/3c05363eeaec5ef16111d6641af2c7f7 to your computer and use it in GitHub Desktop.
SQLite
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ sqlite3 path-to-database-file | |
| sqlite> .tables # list tables | |
| sqlite> .headers ON | |
| sqlite> .mode columns | |
| sqlite> PRAGMA table_info(table_name); # table schema | |
| sqlite> SELECT type, name, tbl_name FROM sqlite_master WHERE type='index'; | |
| # list index |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment