2019. 5. 23. 16:09
SQL SERVER
SELECT IndexName = i.Name, ColName = c.Name FROM sys.indexes i INNER JOIN sys.index_columns ic ON ic.object_id = i.object_id AND ic.index_id = i.index_id INNER JOIN sys.columns c ON c.object_id = ic.object_id AND c.column_id = ic.column_id WHERE ic.is_included_column = 1 ORDER BY i.Name
https://stackoverflow.com/questions/18172359/list-all-indexes-with-included-columnsnonkeys
'SQL SERVER' 카테고리의 다른 글
| tempdb 할당 경합(Tempdb allocation contention) (0) | 2019.08.30 |
|---|---|
| 새로운 서버로 Data 이관(How to migrate SQL Server from one machine to another) (0) | 2019.06.17 |
| Extended Event Data Query로 Select (0) | 2019.02.19 |
| Procedure나 Function 내용 검색 (0) | 2018.10.27 |
| SQL SERVER Wait type 조사 (0) | 2018.10.27 |