All SQL Server Tables in a Schema

DECLARE @schema SYSNAME;
SET @schema = N'some_schema';

SELECT [table] = s.name + N'.' + t.name
  FROM sys.tables AS t
  INNER JOIN sys.schemas AS s
  ON t.[schema_id] = s.[schema_id]
  WHERE s.name = @schema;

Source: mssqltips.com

Similar codes

11 votes124 views3 answers
Unity pick random number
C#
0 vote109 views1 answer
C# short max length
C#
2 votes124 views2 answers
How get query from url in laravel
C#
0 vote113 views1 answer
Add mime type for woff in web.config
C#
0 vote95 views1 answer
C# loop 2 time tables
C#
0 vote99 views1 answer
C# week refrences
C#
0 vote110 views1 answer
My context class is in different project and i want migration in different project in asp.net mvc
C#
0 vote138 views1 answer
How to make game object transparent in unity
C#Unity
0 vote99 views1 answer
C# nunit test case
C#
0 vote107 views1 answer
Elasticsearch nested aggregation in c#
C#