I want to delete specific values/data from one column with the
DELETE FROM CIVILITE WHERE CIV_LIBELLE='Aucun';
The DELETE statement is in conflict with the constraint REFERENCE
"FK_PERS_CIVILITE". The conflict occurred in database "DBDB",
"dbo.PERSONNE" table, column 'ID_CIVILITE'.
The reason why you are getting this error is because you are trying to delete a row which is being referenced by another row hence resulting in the error. So either delete the reference row or remove the constraint temporarily. You need to first alter your table like this:
ALTER TABLE [DBDB].[dbo].[PERSONNE] NOCHECK CONSTRAINT [FK_PERS_CIVILITE]
and then you can delete the record.
Make sure that once you delete the record you apply the constraint again.
ALTER TABLE [DBDB].[dbo].[PERSONNE] WITH CHECK CHECK CONSTRAINT [FK_PERS_CIVILITE]