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;

Technorati Tags: sql server, oracle, mysql, database, sql

Related posts:

1. Desc SQL Tables
2. Query Managed Auto Increment
3. MySQL Admin
4. Create SQL Server Database and Database Tables From a File
5. Copy Data Between Two Database Tables