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

1 vote187 views1 answer
C# datagridview row delete
C#
1 vote144 views1 answer
Hcf of numbers
C#
1 vote202 views1 answer
Unity C# catch index out or range exception
C#Unity
-1 vote243 views2 answers
How to make the player look around in unity 3d
C#Unity
1 vote164 views1 answer
Unity key up
C#
0 vote159 views1 answer
Convert iqueryable to list c#
C#
1 vote171 views1 answer
Mymove() method c#
C#
3 votes168 views1 answer
C sharp split by newline
C#
1 vote154 views1 answer
How to create a delegate in c#
C#
1 vote164 views1 answer
Test how catch exception c#
C#