if it's SQL Server you can use: select table_name from information_schema.tables if it's Oracle you can use the meta data views, like: select * from user_tables; -- modified at 14:16 Monday 15th January, 2007
if it's SQL Server you can use: select table_name from information_schema.tables if it's Oracle you can use the meta data views, like: select * from user_tables; -- modified at 14:16 Monday 15th January, 2007