How to show the list of userdefined tables with schema April 07, 2011 SELECT s.name+'.'+t.name FROM sys.objects t INNER JOIN sys.schemas s on t.schema_id = s.schema_id WHERE type = 'U' ORDER BY 1 Read more