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

-3 votes118 views1 answer
How to split a string by in c#
C#
1 vote179 views1 answer
This in unity
C#Unity
1 vote132 views1 answer
Remove backcolor c#
C#
1 vote129 views2 answers
Using (SqlDataReader sdr = cmd.ExecuteReader())
C#
21 votes153 views2 answers
Unity yield return
C#Unity
1 vote131 views1 answer
Get dropdown selected value unity
C#
1 vote124 views1 answer
Newline in button wpf
C#
18 votes129 views6 answers
C# append array
C#
2 votes140 views1 answer
How to chagne rotation in unity
C#Unity
0 vote125 views1 answer
How to convert int to char in c#
C#