11 02 2009
MS SQL Show Tables in a Database (Microsoft SQL)
In MS SQL use the following SQL to show all tables in the selected database. This is the equivalent of MySQLs show all tables.
MS SQL queries for show table:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';
Using this query syntax you can display all tables in a MS SQL database. Hmmm… I think I like the MySQL way for showing all tables better:
SHOW ALL TABLES;
Drop me a comment if this helped your or if you feel I missed something, thanks for reading.