Use Test Go Select * From sys.objects As a Where Type='U' And is_ms_shipped=0 And Not Exists(Select 1 From sys.extended_properties Where major_id=a.object_id And minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support' )
说明:列出数据库里所有的表名 select name from sysobjects where type='U'
select * from sysobjects where xtype='U'
Go
Select *
From sys.objects As a
Where Type='U' And is_ms_shipped=0 And
Not Exists(Select 1
From sys.extended_properties
Where major_id=a.object_id And
minor_id = 0 and
class = 1 and
name = N'microsoft_database_tools_support'
)
select name from sysobjects where type='U'