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 vote139 views1 answer
Could not load file or assembly 'Ubiety.Dns.Core, Version=2.2.1.0
C#
1 vote124 views1 answer
Asp.net validate web.config
C#
0 vote127 views1 answer
Listbox items to string c#
C#
0 vote115 views1 answer
Web client ignore ssl error
C#
0 vote210 views1 answer
Unity when is awake called
C#Unity
1 vote153 views1 answer
Slider.onchanged in unity
C#
0 vote126 views1 answer
Restart animation unity
C#
1 vote179 views1 answer
Unity c# check how many of an object exists
C#Unity
1 vote130 views1 answer
C# read lines number 3 from string
C#
0 vote125 views1 answer
Is odd c# stackoverflow
C#