I have two tables (master and child).relation between the two tables is they are linked by a column employeeid.I have records in these two tables. Now i have removed the foreign key constraint from the child table by using this st/ Alter table Emp_Status drop constraint Emp_FK01 When i did this,it showed constraint dropped successfully. Now when i try to insert records into the child table, i get the following error: The record can't be added or changed. Referential integrity rules require a related record in table 'EmpMaster'. I gave sp_help emp_status , and saw no constraints,i also checked this query, select * from sysobjects where xtype='F', the constraint was not there. Still i could not add records to the child table.Any help will be appreciated.