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 vote197 views1 answer
Unity Reverse string
C#
0 vote224 views1 answer
Override GetHashCode
C#
0 vote208 views1 answer
ENUM error codes all
C#
0 vote203 views1 answer
How to add onclick event dynamically in unity
C#
0 vote252 views3 answers
C# replace multiple characters
C#
2 votes189 views1 answer
C# string format sepperate every thousand
C#
1 vote215 views1 answer
C# datagridview row delete
C#
0 vote188 views1 answer
Get all assemblies c#
C#
0 vote218 views1 answer
Concatenation on different lines in f#
C#
2 votes186 views1 answer
How to change the position of a gameobject in c# unity
C#