access数据库用sql语句添加字段，修改字段，删除字段

CREATE TABLE Table1 (Id COUNTER CONSTRAINT PrimaryKey PRIMARY KEY, MyText TEXT (10))

CREATE TABLE Table2 (Id LONG, MyText TEXT)

ALTER TABLE Table2 ADD CONSTRAINT Relation1 FOREIGN KEY ([Id]) REFERENCES Table1 ([Id]) ON UPDATE CASCADE ON DELETE CASCADE

ALTER TABLE Table2 DROP CONSTRAINT Relation1

DROP TABLE Table1

ALTER TABLE 表1 ALTER COLUMN [id] COUNTER CONSTRAINT MyPrimaryKey PRIMARY KEY

alter table AAA add COLUMN MySalary CURRENCY

alter table AAA drop COLUMN MySalary