Posted by: cadarsh89 on Aug 06, 2010
select a.name+'.'+b.name from sys.schemas a, sys.tables bwhere a.schema_id = b.schema_id order by a.name