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 vote135 views1 answer
Unity position ui element
C#Unity
0 vote146 views1 answer
Check if process is open c#
C#
0 vote107 views1 answer
C# Returning Strings
C#
4 votes143 views1 answer
Unity spherecast
C#Unity
0 vote101 views1 answer
Tachyons
C#
2 votes95 views1 answer
C# number in range
C#
0 vote96 views1 answer
Clear highlight winforms treeview
C#
0 vote96 views1 answer
Web socket background.js example
C#
15 votes91 views5 answers
Call function from another script unity
C#
16 votes74 views1 answer
For loop on enum c#
C#