인덱스 정의서

인덱스 정의서

--인덱스 정의서 select OBJECT_NAME(a.object_id) TableName, '' kortablename, a.name IndexName, TYPE_NAME(a.type) TypeName, Type_desc, is_unique , index_column_id colseq , COL_NAME(a.object_id, column_id) colName , (case when is_descending_key = 1 then 'DESC' else 'ASC' end) sortType from sys.indexes A join sys.index_columns B on a.object_id=b.object_id and a.index_id=b.index_id