#MySQL/InnoDB
SHOW TABLES
#MySQL/MyISAM
SHOW TABLES
#Sybase
SELECT table_name FROM sys.systable where creator = '1'
##SELECT name FROM test ..sysobjects WHERE type = 'U' and uid = 1
#Oracle
SELECT table_name FROM user_tables
#Microsoft SQL Server
SELECT name FROM test ..sysobjects WHERE xtype = 'U'