How can I specify rules for foreign keys in Microsoft Access using SQL?
- by Genba
I have to create some tables in Microsoft Access using SQL sentences, and some of the tables have foreign keys.
I would like to specify the constraints and rules for foreign keys using SQL:
Whether null is allowed or not
Delete rule
Update rule
How can I specify rules for foreign keys in Microsoft Access using SQL?