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 vote114 views1 answer
How to check if bool is true c#
C#
0 vote115 views1 answer
Prevent C# app from lingering after closing in background processes
C#
0 vote129 views2 answers
C# linq unique by property
C#
0 vote114 views1 answer
How to make a circuit board
C#
0 vote104 views1 answer
Entity framework core genetare class using existing database
C#
0 vote112 views1 answer
Func<IDataRecord, T> c#
C#
0 vote111 views1 answer
Isdaylightsavingtime in c#
C#
5 votes137 views2 answers
How to deactivate an object unity
C#Unity
3 votes106 views1 answer
Executable path with app name c#
C#
0 vote104 views1 answer
C# int array add number
C#