Eruditing Idiot
Pages
Home
About Me
Messages
Free Games
Sunday, April 22, 2012
[Ubuntu][Sqlite3] Display all Tables
Here's how to display all tables on ubuntu terminal
Activate sqlite3:
sqlite3 my_database_name.db
Display all tables:
SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment