SELECT SysUsers.[Name] AS Owner, Object_Name(SysIndexes.ID) AS TableName, SysIndexes.[Name] AS IndexName, [InDID] From SysIndexes Inner Join SysObjects On SysObjects.[ID]=SysIndexes.[ID] Inner Join SysUsers On SysUsers.[UID]=SysObjects.[UID] Where ObjectProperty(SysIndexes.[ID],'IsSystemTable')=0 And ObjectProperty(SysIndexes.[ID],'IsUserTable')=1 And [InDID]>0 And [InDID]<255 And [first] IS NOT NULL
No comments:
Post a Comment