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;