Posted by Sam on 10/01/18 11:38

Hi,
The following request select a constraint from TABLE_CONSTRAINT with
the name specified in the where clause:

select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_name = 'FK__51OtherParties__51Claims'

It returns:

http://graphicsxp.free.fr/constraint.JPG

So I have TABLE_NAME that correspond to the first table involved in the
constraint, but how do I get 51Claims ????


Thank you

• Next in forum: Problem ith DTS and delimited file with empty last column
• Prev in forum: Re: Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
• Thread view: how to get tables involved in constraint

[Reply to this message]