SQLite

Enter the database:

sqlite3 users.db

Show all tables:

SELECT name FROM sqlite_master WHERE type='table';

or

.tables

Show table schema:

.schema table_name

or

pragma table_info(users);