sql - 在表中使用两个外键和'on delete cascade'
问题描述
CREATE TABLE Comments(
Id INT PRIMARY KEY IDENTITY(0,1),
TEXT NOT NULL,
Date Date NOT NULL ,
Point INT NOT NULL DEFAULT(0),
ID_User INT FOREIGN KEY REFERENCES Users(Id) ON DELETE CASCADE NOT NULL,
ID_Post INT FOREIGN KEY REFERENCES Posts(Id) NOT NULL
)
当我从用户表中删除用户时,它显示评论表有其他参考键的错误。我必须做什么?
DELETE 语句与 REFERENCE 约束“FK__Comments__ID_Pos__76969D2E”冲突。冲突发生在数据库“Facebook”、表“dbo.Comments”、列“ID_Post”中。
解决方案
如果要删除用户记录,则需要删除外键表中的记录。
在这种情况下,您需要删除Comments
表中的记录。
DELETE from dbo.Commnts
Where ID_User = "userid"
然后,您可以从Users
表中删除用户记录
推荐阅读
- c# - c# concurrent IO requests basics
- python - I have this python code output that I want to export as a .csv file in python?
- c# - How to show a property of type Object in a list
- java - JBoss7 - How to access VAULT password in code
- ruby-on-rails - Rails:Selenium::WebDriver::Error::WebDriverError:不可执行:'chromedriver-helper'
- azure - 无法连接 BLOB 存储
- dart - Is it possible to use material-select with ngModel/ngControl
- java - hexString.toInt(32) NumberFormatException
- php - Extracting class name using DomCrawler
- fpga - Clock signal in kit DE2i 150