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

1 vote296 views2 answers
Get request url in asp.net core
C#
0 vote273 views1 answer
How to use javascriptexecutor for loop in selenium c#
C#
0 vote317 views3 answers
String to camel case c#
C#
2 votes265 views1 answer
How to make something addforce in the direction of something in untiy
C#
1 vote259 views1 answer
How do I print something in the console every frame unity
C#
0 vote274 views1 answer
Cannot resolve scoped service 'Mango.Services.Identity.Initializer.IDbInitializer' from root provider
C#
1 vote268 views1 answer
How to check file path is valid in c#
C#
0 vote301 views1 answer
Email object c#
C#
1 vote255 views1 answer
Get 2d rotation from 2 position math
C#
0 vote271 views1 answer
Reference variable from another script "winforms" c#
C#