本文介绍如何在数据库中为课程提醒表设置外键约束，确保数据一致性，并详细解释了SQL语句的具体应用。
USE [ShiTiKu]
GO
ALTER TABLE [dbo].[T_KeChengTiXing] WITH NOCHECK ADD CONSTRAINT [FK_T_KeChengTiXing_T_Course] FOREIGN KEY([course_id])
REFERENCES [dbo].[T_Course] ([PK_Course])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[T_KeChengTiXing] CHECK CONSTRAINT [FK_T_KeChengTiXing_T_Course]
GO
ALTER TABLE [dbo].[T_KeChengTiXing] WITH NOCHECK ADD CONSTRAINT [FK_T_KeChengTiXing_T_Course] FOREIGN KEY([course_id])
REFERENCES [dbo].[T_Course] ([PK_Course])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[T_KeChengTiXing] CHECK CONSTRAINT [FK_T_KeChengTiXing_T_Course]
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
