Created
November 18, 2016 05:05
-
-
Save verdimrc/43694f08f58b62ec33f5f89d606612be to your computer and use it in GitHub Desktop.
sqlite SQL
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
| -- Show all tables | |
| .schema | |
| -- Show DDL of a specific table | |
| .schema table1 | |
| -- Show columns | |
| pragma table_info(t1) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment