Wednesday, March 7, 2012

Retrieve table names

How can I get a list of the names of the tables inside a database?

The following command will do that trick:

Code Snippet

SELECT * FROM INFORMATION_SCHEMA.TABLES

No comments:

Post a Comment