How can I specify rules for foreign keys in Microsoft Access using SQL?
Posted
by Genba
on Super User
See other posts from Super User
or by Genba
Published on 2010-06-05T12:17:53Z
Indexed on
2010/06/05
12:23 UTC
Read the original article
Hit count: 241
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?
© Super User or respective owner