Hola Jere_84
Has repasado bien la SQL, la he realizado en mi ordenador y funciona correctamente, porque utilizas alias tan largos.
En vez de sys.columns
AS Columnas, utiliza
AS C, o algo parecido.
Código SQL
[-]SELECT
C.name AS CAMPO
FROM sys.columns AS C
INNER JOIN sys.index_columns AS IC
ON IC.object_id = c.object_id AND IC.column_id = C.column_id
INNER JOIN sys.indexes AS I
ON I.object_id = IC.object_id AND I.index_id = IC.index_id
WHERE I.name = 'PKUC_IDEMPLEADO'
Un saludo.