Using SQL to build tables and set up constraints

[Chunk]

Is it possible to use SQL to code tables and set up constraints on your fields?

I know quite a lot of Oracle SQL, and im used to working within an SQL*Plus command line type environment.

I know the syntax is different, but if I can use access in this way it would really help. Can someone tell me if it possible to do this, and if so how.

Thanks.

 

[Chunk]

Yes. Open the query builder in SQL view and type in the DDL. To get syntax for Jet DDL, open Help and select the Table of Contents. Drill down to Microsoft Jet SQL Reference and then to Data Definition Language.

I can't believe you think it is easier to create tables this way than to use the GUI table designer and relationships window. But to each his own.

Ive been taught solely using oracle sql*plus, so it seems normal to me. Its more writting the check constraints etc that I find easier.

Thanks very much for the help.