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

2 votes202 views1 answer
C# implement ienumerable t
C#
5 votes176 views4 answers
C# adding two arrays together
C#
0 vote179 views1 answer
How to use open hardware monitor in c#
C#
1 vote225 views1 answer
How to close an application in c#
C#
3 votes194 views2 answers
Unity cos
C#Unity
1 vote163 views1 answer
Unity add addressables
C#
0 vote164 views1 answer
How to make a block disappear in unity
C#
0 vote178 views1 answer
.net get system environment variable
C#
1 vote211 views1 answer
Double tryparse dot comma
C#
15 votes177 views4 answers
How to remove white spaces from string in c#
C#