Thanks!!
>Can you use INFORMATION_SCHEMA instead?
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.
>>
>>Here's what I have so far, but as you can see with the portion immediately following the sp_pkeys SP, it is incomplete and destined for failure.
>>
>>SELECT sysobjects.name, sp_pkeys sysobjects.name
>>FROM sysobjects
>>WHERE (id IN
>> (SELECT DISTINCT parent_obj FROM sysobjects WHERE xtype = 'TR'))
>>ORDER BY name
>>
>>Any suggestions?
>>
>>Doug