The DELETE statement conflicted with the REFERENCE constraint....
Posted on 2011-02-27
Ran the command: DELETE FROM [dbo].[USERS]
Got the result:
Msg 547, Level 16, State 0, Line 2
The DELETE statement conflicted with the REFERENCE constraint "FK__Institute__cd_ca__541767F8". The conflict occurred in database "Nova", table "dbo.Institute", column 'cd_userlist'.
The statement has been terminated.
How can I fix this? I need to delete the data inside the table USERS.