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 vote179 views1 answer
Anonymous class c#
C#
0 vote181 views1 answer
How to add logo in a unity game apk
C#
0 vote197 views1 answer
C# if with obj params
C#
1 vote201 views1 answer
How get pice of text in laravel
C#
0 vote185 views1 answer
Unity aspect ratio
C#
0 vote184 views1 answer
How to disable vsync in monogame
C#
0 vote206 views1 answer
Get date value from datepicker c#
C#
0 vote191 views1 answer
Redirect to another controller page in asp.net core
C#
4 votes208 views1 answer
C# minimize form
C#
0 vote176 views2 answers
Get after point in c#
C#