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 vote141 views1 answer
C# linq distinct group by nested list
C#
2 votes127 views1 answer
How to get specific length of row in matrix c#
C#
0 vote134 views1 answer
Count number of properties on an object C#
C#
1 vote129 views1 answer
How to use double in c#
C#
0 vote152 views1 answer
How to coppy a portion of an array in c#
C#
0 vote130 views1 answer
How to draw a dot in c#
C#
4 votes125 views1 answer
ALWAYS MAximize window on start c#
C#
0 vote125 views1 answer
How to set foreground from code wpf
C#
3 votes144 views1 answer
Unity on mousewheel down
C#
5 votes188 views1 answer
Unity createassetmenu
C#Unity