>>Hi,
>>
>>I have been looking on various sites for the code to drop a constraint if I know the name of the constraint. Each site has a different code. I am confused. I would like something that would work on SQL Server 2005 and SQL Server 2008. What would you recommend?
>>
>>TIA.
>>
>>UPDATE. This is the code that works on my SQL Server 2008. Does it look like the right one?:
>>
>>
>>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FK_table_name_fk_field]')
>> AND parent_object_id = OBJECT_ID(N'[dbo].[table_name]'))
>> BEGIN
>> ALTER TABLE [dbo].[table_name]
>> DROP CONSTRAINT [FK_table_name_fk_field]
>> END
>>
>
>I don't think you need an extra check for parent_object_id. I believe the constraint names should be unique across database, not table wise (I'm going to test this quickly).
Yes, I see what you are saying. I just found this code that was checking the table name as well and adopted for my use.
I figured it can't hurt, right?
So far in my tests, the syntax works.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham