Show SQL Tables
When working with a database sometimes you will want to look up all the available database tables. To show the available tables in SQL Server you can do the following:
select * from information_schema.tables;
In Oracle you can use any of the following statements:
select * from user_tables; select * from all_tables;
In MySQL I have been using the following since MySQL 3:
show tables;
But in MySQL 5 you can use the following:
select * from information_schema.tables;