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 vote179 views1 answer
SerializedObjectNotCreatableException: Object at index 0 is null
C#
0 vote207 views1 answer
How to make colliders collide with some things but not other in unity
C#Unity
0 vote154 views1 answer
Disable alt + f4 in c# forms
C#
4 votes153 views4 answers
How to use distinct in linq query in c#
C#
2 votes161 views3 answers
Adding to a dictionary class c#
C#
1 vote192 views1 answer
How to create empty ui object unity
C#Unity
6 votes146 views1 answer
Unity call function on animation end
C#
4 votes189 views1 answer
Unity replace a text in a string
C#Unity
95 votes215 views6 answers
C# string reverse
C#
0 vote185 views2 answers
What is c# used for
C#