SQL: Get list of tables SQL DBs

MySQL
SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern']

Oracle
SELECT * FROM dba_tables

Postgres
SELECT * FROM pg_tables

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

DB2SELECT * FROM SYSCAT.TABLES


Reference:
http://forums.whirlpool.net.au/archive/523219