=============================================
How do you show all the tables in a database?
=============================================
MySQL - http://dev.mysql.com/doc/refman/5.0/en/show-tables.html

SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern']
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

Oracle

SELECT * FROM dba_tables
SELECT * FROM all_tables
SELECT * FROM user_tables

(all_views for views, etc.)

Postgres

SELECT * FROM pg_tables

MSSQL

SHOW TABLES;
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

DB2

SELECT * FROM SYSCAT.TABLES
=============================================


MS SQL Notes
View Transaction Log:
DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
DBCC log (myDB)