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