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 vote108 views1 answer
How to add an embedded resource in visual studio code
C#
3 votes102 views1 answer
C# invert array
C#
1 vote107 views1 answer
Warum wächst Weizen besonders gut in den Steppen?
C#
0 vote100 views1 answer
C# map number range
C#
0 vote121 views1 answer
C# Convert 1 range to another
C#
0 vote129 views1 answer
Unity how to check index of enum
C#Unity
0 vote98 views1 answer
Dictionary all key where value c#
C#
6 votes119 views2 answers
Unity reset rigidbody velocity
C#
2 votes94 views2 answers
C# winforms select folder dialogue
C#
1 vote95 views1 answer
Fon der lajen
C#