Full representation of a table with schema

Posted by: cadarsh89

Tagged in: Untagged 


select a.name+'.'+b.name from sys.schemas a, sys.tables b
where a.schema_id = b.schema_id order  by a.name