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

23 votes116 views2 answers
Unity serializefield
C#
5 votes129 views4 answers
C# linq foreach example
C#
2 votes130 views2 answers
How to convert object in string JSON c#
C#
0 vote134 views1 answer
C# sqlite query
C#
0 vote164 views2 answers
Add RowDefinition from cs xamarin
C#
0 vote137 views1 answer
Serenity.is required field
C#
-1 vote129 views1 answer
Make sprite invisible unity
C#
0 vote134 views1 answer
Gersener waves
C#
0 vote123 views1 answer
Checkbox on change c# xamarin forms
C#
0 vote140 views1 answer
Slider script unity
C#