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

0 vote173 views1 answer
C# make a negative number positive
C#
31 votes303 views3 answers
Create new gameobject unity
C#Unity
2 votes181 views1 answer
Move in the direction that player is facing unity
C#
0 vote245 views1 answer
Ignore warning openxml
C#
6 votes221 views1 answer
Callback function on animation end unity
C#Unity
0 vote163 views1 answer
C# handle dbnull value
C#
0 vote293 views1 answer
Vb.net wait 1 second
C#
0 vote170 views1 answer
Regex for accepting a file name c#
C#
-3 votes164 views2 answers
C# how to append in array
C#
117 votes548 views6 answers
Random number in C#
C#