Sql Server查询所有用户表，排除sysdiagrams系统表

			 
			 
select s.name as TableName,(case when p.value is not null then p.value else '' end) as Description 
from 		 
(select t.name,t.object_id,CAST(
 case 
    when t.is_ms_shipped = 1 then 1
    when (
        select 
            major_id 
        from 
            sys.extended_properties  
        where  
            major_id = t.object_id and 
            minor_id = 0 and 
            class = 1 and 
            name = N'microsoft_database_tools_support') 
        is not null then 1
    else 0
end          
             AS bit) AS [IsSystemObject] from sys.tables t)
             s left join sys.extended_properties
 p on p.major_id=s.object_id and p.minor_id=0

			 where s.IsSystemObject<>1