Delete a table relationship with a Jet SQL statement in Access

How do I build tables and relationships with Jetsql DDL statements?

Microsoft Access contains Datadefinitionlanguage (DDL) to create a delete table and relationships, of course, this can also be solved with DAO.

Here's an example:

Create a table Table1 with DDL createtable, the primary key is an AutoNumber field, and the other is a text field of length 10.

CREATETABLETable1 (Idcounterconstraintprimarykeyprimarykey,mytexttext (10))

To build a table Table2 with two fields, the field ID is a long integer, and the field mytext is text

CREATETABLETable2 (Idlong,mytexttext)

Establish a one-to-many relationship between Table1 and Table2 with the following statement:

Altertabletable2addconstraintrelation1foreignkey ([id]) REFERENCESTABLE1 ([id])

Delete a relationship with the following statement:

Altertabletable2dropconstraintrelation1

Delete Table1 with the following statement:

DROPTABLETable1

Set a field as the primary key

altertable Table 1altercolumn[id]counterconstraintmyprimarykeyprimarykey

Add a field mysalary

Altertableaaaaddcolumnmysalarycurrency

Delete a field mysalary

Altertableaaadropcolumnmysalary