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

Filed under:
|
|
|

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:

  1. Whether null is allowed or not
  2. Delete rule
  3. Update rule

How can I specify rules for foreign keys in Microsoft Access using SQL?

© Super User or respective owner

Related posts about database

Related posts about microsoft-access