Friday, 3 April 2015

How to list all the tables in SQL Server for particular Schema.?

SELECT t.name FROM sys.tables AS t INNER JOIN sys.schemas AS sON t.[schema_id] = s.[schema_id] WHERE s.name = 'sales';

No comments:

Post a Comment