SQL server deletes foreign key constraints

X first find the constraint name

Then delete it.

Here is an example.

-- Test environment

-- Master table

Create table test1 (id int primary key not null, value int)

Insert test1 select 1, 2

Go

-- Slave table

Create table test2 (id int references test1 (id), value int)

Go

-- Step 1: Find the foreign key constraint name in Table test2

-- 2000

Exec sp_helpconstraint 'test2'

-- The foreign key constraint name can be found in the constraint_name attribute.

-- 2005

Select name

From sys. foreign_key_columns f join sys. objects o on f. constraint_object_id = o. object_id

Where f. parent_object_id = object_id ('test2 ')

/*

Name

---------------------------------

FK _ test2 _ id _ 08EA5793 */

-- Step 2: delete the foreign key constraint

Alter table test2 drop constraint FK _ test2 _ id _ 08EA5793

-- Step 3: Check whether the table contains foreign key constraints.

-- You only need to use the search statement in step 1.