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

Related Posts Plugin for WordPress, Blogger...