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 vote208 views1 answer
C# new keyword
C#
0 vote264 views1 answer
How to add logo in a unity game apk
C#Unity
-2 votes208 views1 answer
C# get folder of full ilepath
C#
0 vote208 views1 answer
C# regex find number in string
C#
3 votes282 views4 answers
Call python script from c#
C#
3 votes201 views1 answer
Get type of variable c#
C#
2 votes216 views2 answers
Vscode unfold all
C#
1 vote193 views3 answers
Unity follow object
C#
1 vote212 views1 answer
String formatting of spacing with c#
C#
7 votes216 views3 answers
Add two numbers in c#
C#