SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu ON tc.CONSTRAINT_name = ccu.CONSTRAINT_name WHERE CONSTRAINT_type = 'PRIMARY KEY'>Hi. I'm attempting to make use of a SP from within a SQL statement. What I would like to return is a table of table names that have a trigger associated as well as the primary key's column name associated with the table. The problem I am having is retrieving the PK for the retrieve tables.