SQL Server 获取表的所有索引

/**
获取指定表的所有索引
*/
CREATE PROC SP_TABLE_INDEX
@TableName NVARCHAR(50)=NULL
AS
IF @TableName IS NULL
BEGIN
     RAISERROR('无效的数据表！',12,1)
     RETURN
END
SELECT C.NAME AS TABLE_NAME,A.NAME AS INDEX_NAME,D.NAME AS INDEX_COLUMN_NAME
FROM SYS.INDEXES A   
JOIN SYS.INDEX_COLUMNS B ON (A.object_id = B.object_id AND A.index_id = B.index_id)   
JOIN SYS.TABLES C ON (A.object_id = C.object_id)   
JOIN SYS.COLUMNS D ON (A.object_id = D.object_id   AND B.column_id = D.column_id)
WHERE C.NAME=@TableName