Friday, 3 April 2015

List all table names of a particular database by SQL query?

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='dbName'
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)