Oracle
SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME
MySQL
SHOW TABLES
MS SQL Server
select name from sysobjects where type = N'U' order by name
DB2 UDB
SELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T' AND CREATOR != 'SYSIBM' ORDER BY NAME
SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME
MySQL
SHOW TABLES
MS SQL Server
select name from sysobjects where type = N'U' order by name
DB2 UDB
SELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T' AND CREATOR != 'SYSIBM' ORDER BY NAME