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

5 votes246 views1 answer
Loop over object properties c#
C#
0 vote291 views2 answers
Unity list get item at index
C#Unity
1 vote236 views1 answer
C# winforms input
C#
0 vote217 views1 answer
How to get error code from exception in c#
C#
0 vote246 views1 answer
Csharp datagridview filter column
C#
1 vote221 views1 answer
How to set a transform equal to something unity
C#
32 votes262 views4 answers
How to get keyboard input in unity
C#Unity
0 vote241 views1 answer
C# 9.0 dynamic nedir
C#
0 vote235 views1 answer
For each property in object c#
C#
0 vote218 views1 answer
Csv to dataset c#
C#