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

16 votes312 views3 answers
C# how to set string list
C#
0 vote303 views1 answer
How to make a string a list of characters c#
C#
-2 votes370 views1 answer
Unity3d sort list
C#Unity
2 votes295 views1 answer
Unity run void from another script
C#
0 vote311 views1 answer
C# convert date to oracle format
C#
-1 vote292 views1 answer
How to create a random vector2 in unity
C#
5 votes304 views2 answers
C# mark as deprecated
C#
0 vote281 views2 answers
Dapper query list of parameters
C#
0 vote329 views1 answer
Unity iap
C#
1 vote329 views2 answers
Convert memorystream to byte array c#
C#