How to check if a Constraint exists in Sql server?

Posted by Lieven Cardoen on Stack Overflow See other posts from Stack Overflow or by Lieven Cardoen
Published on 2010-03-23T11:11:30Z Indexed on 2010/03/23 11:13 UTC
Read the original article Hit count: 113

Filed under:

I have this sql:

ALTER TABLE dbo.ChannelPlayerSkins
    DROP CONSTRAINT FK_ChannelPlayerSkins_Channels

but apparently, on some other databases we use, the constraint has a different name. How do I check if there's a constraint with the name FK_ChannelPlayerSkins_Channels.

© Stack Overflow or respective owner

Related posts about sql-server