USE db357t;
GO
SELECT i.name AS index_name
    ,ic.index_column_id
    ,key_ordinal
    ,c.name AS column_name
    ,TYPE_NAME(c.user_type_id)AS column_type 
    ,is_identity
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic 
    ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c 
    ON ic.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 
    AND i.object_id = OBJECT_ID('TSCUUserRole');
GO

output:
index_name	index_column_id
			key_ordinal
				column_name
					column_type
						is_identity
PK_TScuUserRole	1	1	FUserID	nchar	0
PK_TScuUserRole	2	2	FRoleID	nchar	0