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 vote328 views2 answers
Openiddect ef core table not creating
C#
1 vote375 views1 answer
How to make error sound c#
C#
0 vote370 views1 answer
DisplayUnitType revit api
C#
1 vote363 views2 answers
Append 2 arrays c#
C#
0 vote334 views1 answer
Como usar a função SelectToken em vb net
C#
14 votes333 views4 answers
One line condition c#
C#
1 vote367 views1 answer
Https request c#
C#
0 vote324 views1 answer
Blazor alert
C#
0 vote336 views1 answer
Unity run all interfaces
C#
0 vote388 views1 answer
Compass direction mobile unity
C#Unity