Updating primary key sql Serious privat sex cams

Posted by / 29-Jun-2020 15:25

For this constraint to execute, all foreign key columns must have default definitions.

SET DEFAULT All the values that make up the foreign key are set to their default values if the corresponding row in the parent table is updated or deleted.Sales Person table because there is a logical relationship between sales orders and salespeople.The Sales Person ID column in the Sales Order Header table matches the primary key column of the Sales Person table.ON DELETE CASCADE cannot be specified for a table that has an INSTEAD OF DELETE trigger.ON UPDATE CASCADE cannot be specified for tables that have INSTEAD OF UPDATE triggers.

CASCADE Corresponding rows are updated or deleted in the referencing table when that row is updated or deleted in the parent table.