logo

한국어

Language

select * from sys.indexes



SELECT
     TableName = t.name,
     IndexName = ind.name,
     IndexId = ind.index_id,
     ColumnId = ic.index_column_id,
     ColumnName = col.name,
     ind.*,
     ic.*,
     col.*
FROM
     sys.indexes ind
INNER JOIN
     sys.index_columns ic ON  ind.object_id = ic.object_id and ind.index_id = ic.index_id
INNER JOIN
     sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id
INNER JOIN
     sys.tables t ON ind.object_id = t.object_id
--WHERE
--     ind.is_primary_key = 0
--     AND ind.is_unique = 0
--     AND ind.is_unique_constraint = 0
--     AND t.is_ms_shipped = 0
     -- and ind.name like '%611090259%'
ORDER BY
     ind.name, t.name, ind.index_id, ic.index_column_id
조회 수 :
7539
등록일 :
2016.04.07
23:40:57 (*.175.161.172)
엮인글 :
http://www.cubequest.org/xe/index.php?mid=sql&document_srl=165947&act=trackback&key=82a
게시글 주소 :
http://www.cubequest.org/xe/index.php?document_srl=165947
List of Articles
번호 제목 글쓴이 날짜 조회 수
49 [MYSQL]테이블 크기 확인 Cheeryj 2017-05-01 3009
48 [MYSQL]GROUP_CONCAT persona 2016-10-28 2542
47 Get size of all tables in database persona 2016-10-20 24989
46 Enterprise manager에서 한글로 바뀌는 문제 persona 2016-10-20 1270
45 View the Definition of a Stored Procedure persona 2016-08-03 3083
44 [MSSQL] 테이블 프로시저 존재 체크 persona 2016-07-28 2323
43 [MSSQL] Collation persona 2016-06-23 3895
42 [MSSQL] RESTORE할 때 오류 persona 2016-06-21 2936
41 [MSSQL] Resetting SQL Server Identity Columns: persona 2016-06-20 1725
40 [MSSQL]using SQLCMD persona 2016-06-05 6375
39 PostgreSQL 설치 & 사용법 정리 persona 2016-05-05 21866
38 [PostgreSQL]설치 persona 2016-04-30 34260
» [MSSQL] Index 리스트 얻기 persona 2016-04-07 7539
36 MySQL EXPORT & IMPORT [1] persona 2016-02-20 4943
35 MySQL via MERGE table engine: persona 2015-10-15 13514
34 MySQL charset encoding [1] persona 2015-06-12 5413
33 SQL SERVER INSTANACE LIST persona 2015-04-17 4262
32 SQL JOIN file Cheeryj 2015-03-25 4934
31 SQL SERVER SINGLE USER MODE persona 2015-03-17 5597
30 MSSQL FILESTREAM 활성화 persona 2015-03-17 5514