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 vote165 views1 answer
How to add to a list only items that are not already in the list c#
C#
0 vote165 views1 answer
Asp.net model display name
C#
47 votes180 views5 answers
Remove last character from stringbuilder c#
C#
0 vote167 views1 answer
Unity Rigidbody how to set zero momentum
C#
5 votes169 views4 answers
Linq foreach c#
C#
12 votes180 views2 answers
How to move towards an object unity
C#
2 votes187 views1 answer
C# 2-dimensional array sort
C#
-1 vote167 views2 answers
C# string contain double quote
C#
0 vote162 views1 answer
C# project path
C#
0 vote168 views1 answer
C# get user appdata folder
C#