How to get list of tables in a database

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

Oracle
SELECT table_name FROM user_tables;

MS SQL
sp_help

PostgreSQL
select tablename from pg_tables

Firebird
show table (when using isql)