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 vote253 views1 answer
Unity only one component type
C#Unity
1 vote191 views1 answer
Ultimate space cruiser
C#
0 vote212 views1 answer
Defualtsize UWP c#
C#
0 vote179 views1 answer
C# break file into words
C#
23 votes197 views2 answers
Unity coroutine
C#
0 vote178 views1 answer
Sends keys enter selenium c#
C#
1 vote186 views1 answer
Loop through multidimensional array c#
C#
1 vote263 views1 answer
Unity normalize float
C#Unity
0 vote198 views1 answer
Web3.fromWei(eth.getBalance(eth.coinbase));
C#
0 vote250 views1 answer
Declare string array c# without size
C#