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 vote141 views1 answer
Trhow exception if is null c#
C#
0 vote265 views1 answer
How to iterate through a game object in unity
C#Unity
0 vote139 views1 answer
Change textbox text color c#
C#
0 vote137 views1 answer
3(x-4)-2(3x+4)=4(3-x)+5x+4
C#
0 vote164 views1 answer
Datatable linq where clause c#
C#
0 vote150 views1 answer
.net 4.5 use tls 1.2
C#
1 vote144 views3 answers
Unity follow object
C#
0 vote132 views1 answer
Value is null to insert in c#
C#
0 vote157 views1 answer
Unity normalize movement
C#
0 vote148 views1 answer
Get access to all controls with a specific tag in C#
C#