Wählen Sie Ihren SQL-Server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Neuheiten abonnieren
Partners
Testimonials
Dan Flazer: "Your new product and your assistance with us was excellent...will prove invaluable to the future of our company".
Matt McDawell: "Your practical knowledge & experience, supported by your dedication and hard work set new standards. Taking you into account is the best decision our company has made".

More

Add your opinion

MaxDB Maestro online Help

Prev Return to chapter overview Next

Setting reference options

Set rule ON DELETE from the respective drop-down list.

 

 

RESTRICT Produce an error indicating that the deletion or update would create a foreign key constraint violation.

 

CASCADE Delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively.

 

SET NULL Set the referencing column(s) to null.

 

SET DEFAULT Set the referencing column(s) to their default values.



Prev Return to chapter overview Next