SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE
= 'BASE TABLE' AND TABLE_CATALOG='dbName'
Showing posts with label List all table names of a particular database by SQL query?. Show all posts
Showing posts with label List all table names of a particular database by SQL query?. Show all posts
Friday, 3 April 2015
Subscribe to:
Posts (Atom)