SQLServer. Columnas en constraint

Para obtener las columnas que componen o forman un constraint en Sql Server:
SELECT i.name AS IndexName,OBJECT_NAME(ic.id) AS TableName, COL_NAME(ic.id, ic.colid) AS ColumnName
FROM sysindexes AS i INNER JOIN
sysindexkeys AS ic ON i.id = ic.id AND i.indid = ic.indid
WHERE i.name = 'nombre de la constraint'