My Blog

In MS SQL use the following SQL to show all tables in the selected database.

1

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';

Hmmm… I think I like the MySQL way:

1

SHOW ALL TABLES;

This entry was posted on Wednesday, February 11th, 2009 at 7:14 pm and is filed under rant. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.