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 vote323 views1 answer
C# base vs this
C#
22 votes304 views3 answers
Unity change text color
C#
2 votes324 views1 answer
Unity can't invoke method
C#Unity
2 votes321 views1 answer
Blazor button onclick parameter
C#
14 votes321 views2 answers
C# how to delete a file
C#
0 vote364 views1 answer
Interpolate rotation unity3d
C#Unity
11 votes314 views1 answer
How to edit text mesh pro text
C#
0 vote322 views1 answer
C# datareader already open visual studio mysql
C#
1 vote313 views1 answer
What is namespace in c#
C#
1 vote367 views1 answer
Slider.onchanged in unity
C#Unity