SELECT
	 ist.TABLE_SCHEMA
	,ist.TABLE_NAME
	,COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLES AS ist

OUTER APPLY
(
	SELECT
		STUFF
		(
			(
				SELECT
					 ', ' + ku.COLUMN_NAME AS [text()]
				FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS tc

				INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS ku
					ON tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
					AND tc.CONSTRAINT_NAME = ku.CONSTRAINT_NAME
					AND ku.CONSTRAINT_SCHEMA = tc.CONSTRAINT_SCHEMA
					AND ku.TABLE_SCHEMA = tc.TABLE_SCHEMA
					AND ku.TABLE_NAME = tc.TABLE_NAME

				WHERE (1=1)
				AND CONSTRAINT_TYPE = 'PRIMARY KEY'
				AND tc.TABLE_NAME = ist.TABLE_NAME
				AND tc.TABLE_SCHEMA = ist.TABLE_SCHEMA

				ORDER BY ORDINAL_POSITION
				FOR XML PATH(''), TYPE
			).value('.', 'nvarchar(MAX)')
			,1,2,''
		) AS COLUMN_NAME
) AS pk

WHERE ist.TABLE_TYPE = 'BASE TABLE'
AND ist.TABLE_NAME = 'T_VWS_Attachments'
AND ist.TABLE_SCHEMA = 'dbo'