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 vote295 views1 answer
How to make a simple console select screen using C# ReadKey
C#
0 vote297 views1 answer
How to start grid from where the data starts in c# charts
C#
0 vote268 views3 answers
C# example code
C#
1 vote299 views1 answer
Month number to text in c#
C#
10 votes313 views6 answers
C# convert string to enum
C#
0 vote304 views1 answer
Create entity c# d365
C#
3 votes359 views6 answers
C# timestamp
C#
0 vote280 views2 answers
Combobox in datagrid wpf
C#
1 vote313 views1 answer
How To Get The Global Position of a GameObject in a Variable
C#
0 vote300 views1 answer
For what is percent sign in unity c#
C#