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 vote355 views3 answers
How to use multiple Commands for one ViewModel
C#
0 vote353 views1 answer
C# write to output window
C#
0 vote364 views1 answer
ElevatedButton change color
C#
68 votes422 views6 answers
Format datetime c#
C#
1 vote380 views1 answer
How o remove .meta files visual studio code
C#
1 vote390 views1 answer
Unity json save array
C#
0 vote340 views1 answer
How to print text to screen in c#
C#
1 vote419 views1 answer
How to detect when a player move in unity
C#Unity
1 vote342 views3 answers
Byte[] to base 65 string in C#
C#
2 votes361 views1 answer
How to run a function as administrator in c#
C#