[MSSQL] 테이블의 인덱스 얻기
DECLARE @P_TABLE_NAME NVARCHAR(200); SET @P_TABLE_NAME = 'MyTable'; SELECT CAST(CONVERT(SYSNAME, SI.NAME) AS VARCHAR(776)) AS INDEX_NM, CAST(CONVERT(SYSNAME, SC.NAME) AS VARCHAR(776)) AS COL_NM, CASE WHEN SC.NAME = INDEX_COL(@P_TABLE_NAME, SI.INDID, 1) THEN CONVERT(SMALLINT,1) WHEN SC.NAME = INDEX_COL(@P_TABLE_NAME, SI.INDID, 2) THEN CONVERT(SMALLINT,2) WHEN SC.NAME = INDEX_COL(@P_TABLE_NAME, SI..
2011. 11. 17. 20:30