添加级联

       

alter table 表名
add constraint 外键名
foreign key(字段名) references 主表名(字段名)
on delete cascade

语法：
Foreign Key
(column[,...n])
references referenced_table_name[(ref_column[,...n])]
[on delete cascade]
[on update cascade]
注释：
column:列名
referenced_table_name:外键参考的主键表名称
ref_name:外键要参考的表的主键列
on delete:删除级联
on update:更新级联

 

         ALTER TABLE [dbo].[Alarm]  WITH CHECK ADD  CONSTRAINT [FK_Alarm_AlarmPar] FOREIGN KEY([StateId]) REFERENCES [dbo].[AlarmPar] ([StateId]) ON UPDATE CASCADE  ON DELETE CASCADE";
         ALTER TABLE [dbo].[Alarm]  WITH CHECK ADD  CONSTRAINT [FK_Alarm_Light] FOREIGN KEY([LightID]) REFERENCES [dbo].[Light] ([LightID]) ON UPDATE CASCADE  ON DELETE CASCADE ";
         ALTER TABLE [dbo].[Monitor]  WITH CHECK ADD  CONSTRAINT [FK_Monitor_Light] FOREIGN KEY([LightID]) REFERENCES [dbo].[Light] ([LightID]) ON UPDATE CASCADE ON DELETE CASCADE ";
         ALTER TABLE [dbo].[GprsRecord]  WITH CHECK ADD  CONSTRAINT [FK_GprsRecord_Gprs] FOREIGN KEY([GprsID]) REFERENCES [dbo].[Gprs] ([GprsID]) ON UPDATE CASCADE  ON DELETE CASCADE ";
         ALTER TABLE [dbo].[GprsRoad]  WITH CHECK ADD  CONSTRAINT [FK_GprsRoad_Gprs] FOREIGN KEY([GprsID]) REFERENCES [dbo].[Gprs] ([GprsID]) ON UPDATE CASCADE ON DELETE  CASCADE ";
         ALTER TABLE [dbo].[GprsRoad]  WITH CHECK ADD  CONSTRAINT [FK_GprsRoad_Road] FOREIGN KEY([RoadID]) REFERENCES [dbo].[Road] ([RoadID]) ON UPDATE CASCADE ON DELETE  CASCADE";
         ALTER TABLE [dbo].[Light]  WITH CHECK ADD  CONSTRAINT [FK_Light_Gprs] FOREIGN KEY([GprsID]) REFERENCES [dbo].[Gprs] ([GprsID]) ON UPDATE CASCADE  ON DELETE CASCADE  ";
         ALTER TABLE [dbo].[Light]  WITH CHECK ADD  CONSTRAINT [FK_Light_GroupTable] FOREIGN KEY([GroupID]) REFERENCES [dbo].[GroupTable] ([GroupID]) ON UPDATE CASCADE ON DELETE CASCADE";
         ALTER TABLE [dbo].[Road]  WITH CHECK ADD  CONSTRAINT [FK_Road_Area] FOREIGN KEY([AreaID]) REFERENCES [dbo].[Area] ([AreaID]) ON UPDATE  CASCADE ON DELETE CASCADE";
         ALTER TABLE [dbo].[GroupTable]  WITH CHECK ADD  CONSTRAINT [FK_GroupTable_FirstGroup] FOREIGN KEY([FirstGroupID]) REFERENCES [dbo].[FirstGroup] ([FirstGroupID]) ON UPDATE CASCADE ON DELETE CASCADE";
         ALTER TABLE [dbo].[GroupTable]  WITH CHECK ADD  CONSTRAINT [FK_GroupTable_Plan] FOREIGN KEY([PlanID]) REFERENCES [dbo].[PlanTable] ([PlanID]) ON UPDATE CASCADE ON DELETE CASCADE";
         ALTER TABLE [dbo].[GroupTable] CHECK CONSTRAINT [FK_GroupTable_Plan]";