"Hans [DiaGraphIT]" <hans.ar***@sshf.no> wrote in message
news:ABFCB48A-590E-4C05-B308-A40C67ED3C41@microsoft.com...
> Hi!
>
> I want to create constraints, but I want to check if the constraint exists
> first.  How do I do that?
>
> I think something like following example would work for me, but I'm not
> sure
> how to check... filling the space between ...exists (...)
>
> IF NOT EXISTS (.......)
> ALTER TABLE UserTable
>    ADD CONSTRAINT Language_UserTable FOREIGN KEY (fk_LanguageID)
> REFERENCES
> Language (LanguageID) ON DELETE CASCADE ON UPDATE CASCADE
> GO
>
> Please help
> ---------------
> Best regards
> - Hans -
> ---------------

"Uri Dimant" wrote:

> Hans
> Take a look at INFORMATION_SCHEMA.TABLE_CONSTRAINTS view
>
>
> "Hans [DiaGraphIT]" <hans.ar***@sshf.no> wrote in message
> news:ABFCB48A-590E-4C05-B308-A40C67ED3C41@microsoft.com...
> > Hi!
> >
> > I want to create constraints, but I want to check if the constraint exists
> > first.  How do I do that?
> >
> > I think something like following example would work for me, but I'm not
> > sure
> > how to check... filling the space between ...exists (...)
> >
> > IF NOT EXISTS (.......)
> > ALTER TABLE UserTable
> >    ADD CONSTRAINT Language_UserTable FOREIGN KEY (fk_LanguageID)
> > REFERENCES
> > Language (LanguageID) ON DELETE CASCADE ON UPDATE CASCADE
> > GO
> >
> > Please help
> > ---------------
> > Best regards
> > - Hans -
> > ---------------
>
>
>