delete table issues
Posted on 2010-09-07
I have created a few tables into a DB.
For some reason I need to remove all the tables I have created.
I have removed all the tables except one.
I am getting an error like this while trying the sql
delete from MappedRuleSet
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "MappedRuleSet_TitleFilePartMapping_FK1". The conflict occurred in database "SS_TEST", table "dbo.TitleFilePartMapping", column 'MappingRuleSetID'.
The statement has been terminated.