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 votes346 views1 answer
Unity look at target
C#
1 vote375 views1 answer
How to spawn coins randomly around the screen unity 2d
C#Unity
0 vote323 views1 answer
Check .net installing
C#
0 vote311 views1 answer
C# console out restore
C#
0 vote327 views1 answer
C# week refrences
C#
0 vote315 views2 answers
Install nuget package for S3
C#
1 vote334 views1 answer
C# System.Resources.MissingManifestResourceException error
C#
0 vote346 views1 answer
Asp.netcore: develop on win10 run on ubuntu
C#
0 vote314 views1 answer
Begininvoke async c#
C#
0 vote321 views2 answers
C# optional parameters
C#