ALTER TABLE [dbo].[agregate_shutdown_reason] ADD CONSTRAINT [FK_agregate_shutdown_reason_responsible_service_responsible_service_id] FOREIGN KEY ([responsible_service_id]) REFERENCES

Question

Пользователь 61954

ALTER TABLE [dbo].[agregate_shutdown_reason] ADD CONSTRAINT [FK_agregate_shutdown_reason_responsible_service_responsible_service_id] FOREIGN KEY ([responsible_service_id]) REFERENCES

[dbo].[responsible_service] ([id]) ON DELETE NO ACTION;
System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_agregate_shutdown_reason_responsible_service_responsible_service_id". The conflict occurred in database "fitwebui-kto", table "dbo.responsible_service", column 'id'.что делаю не так?

#backend #dot #programming #russian

0

26.12.2018

1 ответов

11 просмотров

Dr. Friedrich von Never · Accepted Answer

Dr. Friedrich von Never

Может, типы полей не совпадают?

0

26.12.2018

170 похожих чатов

ALTER TABLE [dbo].[agregate_shutdown_reason] ADD CONSTRAINT [FK_agregate_shutdown_reason_responsible_service_responsible_service_id] FOREIGN KEY ([responsible_service_id]) REFERENCES

1 ответов

Похожие вопросы