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 vote140 views14 answers
}
C#
4 votes274 views3 answers
Public gameobject unity
C#Unity
1 vote187 views1 answer
C# set file invisible
C#
0 vote157 views1 answer
Unity android keycodes
C#
30 votes161 views3 answers
C# check file exists
C#
0 vote167 views1 answer
Bootstrap distane between col
C#
0 vote148 views1 answer
Remove tag anchor and inside tag from html raw text c#
C#
0 vote161 views1 answer
How to make pc bsod C#
C#
0 vote190 views1 answer
Adding values to mock IHttpContextAccessor unit test .net core
C#
0 vote148 views1 answer
Register all services microsoft .net core dependency injection container
C#