^全^ 获取SQL SERVER2000/2005、MySql、Oracle元数据的SQL语句(1)
SELECTi.name,
i.status,
i.indid,
i.OrigFillFactor,
IndCol1= INDEX_COL(@tablename, i.indid, 1),
IndCol2= INDEX_COL(@tablename, i.indid, 2),
IndCol3= INDEX_COL(@tablename, i.indid, 3),
IndCol4= INDEX_COL(@tablename, i.indid, 4),
IndCol5= INDEX_COL(@tablename, i.indid, 5),
IndCol6= INDEX_COL(@tablename, i.indid, 6),
IndCol7= INDEX_COL(@tablename, i.indid, 7),
IndCol8= INDEX_COL(@tablename, i.indid, 8),
IndCol9= INDEX_COL(@tablename, i.indid, 9),
IndCol10 = INDEX_COL(@tablename, i.indid, 10),
IndCol11 = INDEX_COL(@tablename, i.indid, 11),
IndCol12 = INDEX_COL(@tablename, i.indid, 12),
IndCol13 = INDEX_COL(@tablename, i.indid, 13),
IndCol14 = INDEX_COL(@tablename, i.indid, 14),
IndCol15 = INDEX_COL(@tablename, i.indid, 15),
IndCol16 = INDEX_COL(@tablename, i.indid, 16),
IsDescCol1= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 1,N'isdescending'),
IsDescCol2= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 2,N'isdescending'),
IsDescCol3= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 3,N'isdescending'),
IsDescCol4= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 4,N'isdescending'),
IsDescCol5= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 5,N'isdescending'),
IsDescCol6= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 6,N'isdescending'),
IsDescCol7= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 7,N'isdescending'),
IsDescCol8= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 8,N'isdescending'),
IsDescCol9= INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 9,N'isdescending'),
IsDescCol10 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 10, N'isdescending'),
IsDescCol11 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 11, N'isdescending'),
IsDescCol12 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 12, N'isdescending'),
IsDescCol13 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 13, N'isdescending'),
IsDescCol14 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 14, N'isdescending'),
IsDescCol15 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 15, N'isdescending'),
IsDescCol16 = INDEXKEY_PROPERTY(OBJECT_ID(@tablename), i.indid, 16, N'isdescending'),
IsCompCol1= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 1),N'IsComputed'),
IsCompCol2= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 2),N'IsComputed'),
IsCompCol3= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 3),N'IsComputed'),
IsCompCol4= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 4),N'IsComputed'),
IsCompCol5= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 5),N'IsComputed'),
IsCompCol6= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 6),N'IsComputed'),
IsCompCol7= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 7),N'IsComputed'),
IsCompCol8= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 8),N'IsComputed'),
IsCompCol9= COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 9),N'IsComputed'),
IsCompCol10 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 10), N'IsComputed'),
IsCompCol11 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 11), N'IsComputed'),
IsCompCol12 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 12), N'IsComputed'),
IsCompCol13 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 13), N'IsComputed'),
IsCompCol14 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 14), N'IsComputed'),
IsCompCol15 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 15), N'IsComputed'),
IsCompCol16 = COLUMNPROPERTY(OBJECT_ID(@tablename), INDEX_COL(@tablename, i.indid, 16), N'IsComputed'),
SegName = s.groupname,
IsFullTextKey = INDEXPROPERTY(OBJECT_ID(@tablename), i.name, N'IsFulltextKey'),
IsTable = OBJECTPROPERTY(OBJECT_ID(@tablename), N'IsTable'),
IsStatistics = INDEXPROPERTY(OBJECT_ID(@tablename), i.name, N'IsStatistics'),
IsAutoStatistics = INDEXPROPERTY(OBJECT_ID(@tablename), i.name, N'IsAutoStatistics'),
IsHypothetical = INDEXPROPERTY(OBJECT_ID(@tablename), i.name, N'IsHypothetical'),
IsConstraint = CASE WHEN c.constid IS NOT NULL THEN 1 ELSE 0 END
页:
[1]