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 vote372 views2 answers
List string to int c#
C#
9 votes335 views1 answer
Resize image c#
C#
2 votes306 views1 answer
C# how does comparing datetime work
C#
1 vote327 views1 answer
C# socket listen on port
C#
0 vote306 views1 answer
Convert date to days c#
C#
3 votes326 views3 answers
C# int to byte Array
C#
1 vote415 views1 answer
Unity how to set an objects postion x,y,z
C#Unity
1 vote329 views1 answer
How to create empty ui object unity
C#
0 vote299 views1 answer
C# Convert range
C#
1 vote306 views1 answer
Unity agent does not move
C#