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

16 votes72 views1 answer
For loop on enum c#
C#
15 votes128 views2 answers
Replace space with underscore in c#
C#
17 votes126 views5 answers
Linux delete content of folder
C#
-1 vote110 views1 answer
C# arraylist to listview
C#
3 votes137 views1 answer
How to move your character in unity 2d game
C#Unity
0 vote120 views1 answer
Unity convert number to notation
C#
0 vote131 views1 answer
How to skip bin/Debug/netcoreapp3.1/ on the reltaive path
C#
0 vote127 views1 answer
C# easy
C#
0 vote136 views1 answer
Unity occulision for hide something
C#Unity
1 vote119 views1 answer
Remove index from array c#
C#