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

18 votes160 views4 answers
How to delete all files in a directory c#
C#
0 vote149 views1 answer
Concatenation on different lines in f#
C#
0 vote140 views1 answer
Yanderedev
C#
0 vote183 views1 answer
C# get all letters
C#
1 vote142 views1 answer
C# find longest string in a list
C#
1 vote188 views1 answer
Unity c# set list to set active true
C#Unity
1 vote176 views1 answer
Togl unity
C#Unity
19 votes135 views2 answers
Unity set text value
C#
0 vote139 views1 answer
Dataset empty check C#
C#
1 vote159 views1 answer
How get pice of text in laravel
C#