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

32 votes237 views4 answers
Textmesh pro text unity
C#
0 vote216 views1 answer
Multiply structs c#
C#
1 vote221 views1 answer
C# copy list without reference
C#
1 vote234 views1 answer
Unity get scrollbar value
C#
3 votes228 views1 answer
C# find item in list
C#
0 vote206 views1 answer
Begininvoke async c#
C#
50 votes254 views5 answers
Unity scene load
C#Unity
0 vote209 views1 answer
C# How to read users input and display it
C#
7 votes227 views1 answer
How to convert string to guid c#
C#
0 vote214 views1 answer
Hahhaa i hack u
C#