|
/*
Obtaining the table name and schema from metadata tables
for user tables only
*/
select o.name as [Name], sc.name as [Type]
from sys.objects o
left join sys.schemas sc on sc.schema_id = o.schema_id
where o.type = 'U'
order by sc.name, o.name
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.