Posted by Razvan Socol on 01/18/06 19:07

Hi, Sam

You can use something like this:

SELECT TC.TABLE_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC
ON TC.CONSTRAINT_NAME=RC.UNIQUE_CONSTRAINT_NAME
AND TC.CONSTRAINT_SCHEMA=RC.UNIQUE_CONSTRAINT_SCHEMA
WHERE RC.CONSTRAINT_NAME = 'FK__51OtherParties__51Claims'

Razvan

• Next in forum: Can I use stored procedures with PHP via ODBC bridge?
• Prev in forum: Re: Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
• Thread view: Re: how to get tables involved in constraint

[Reply to this message]