Jul 7, 2018

How to get table name in MS SQL

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='Your data base name'

No comments:

Post a Comment