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 vote275 views2 answers
Docker-compose cassandra db
C#
1 vote254 views1 answer
Blank background for button wpf
C#
0 vote283 views1 answer
Add values to dictionary c# while initializing
C#
1 vote282 views3 answers
C# string to hex
C#
0 vote300 views1 answer
List of function in c#
C#
36 votes372 views5 answers
How to generate random number in unity
C#Unity
1 vote264 views1 answer
Float and int need help
C#
8 votes272 views2 answers
C# textbox numbers only
C#
0 vote275 views1 answer
Hovercraft in Unity
C#
0 vote280 views1 answer
Csharp 3d array length
C#