我正在尝试创建3个关联表
/ * create customer_dml —这个工作正常* /
DROP TABLE Customer_DML;CREATE TABLE Customer_DML( customerId CHAR(10)CONSTRAINT customer_pk PRIMARY KEY, …
调试DDL的最佳方法是一次删除一行直到它工作,然后开始一次一个地添加这些行,直到您可以隔离有问题的确切行。
在您的DDL中,您有多个语法问题,都与 constraint 句法。
constraint
声明约束时,为其指定名称,然后为约束所属的列。你省略了第二部分。
CONSTRAINT account_nn_customerId NOT NULL 应该 CONSTRAINT account_nn_customerId CustomerID NOT NULL
CONSTRAINT account_nn_customerId NOT NULL
CONSTRAINT account_nn_customerId CustomerID NOT NULL
CONSTRAINT account_fk_customerid REFERENCES Customer_DML(customerId) ON DELETE CASCADE, 应该 CONSTRAINT account_fk_customerid foreign key (CustomerId) REFERENCES Customer_DML(customerId) ON DELETE CASCADE,
CONSTRAINT account_fk_customerid REFERENCES Customer_DML(customerId) ON DELETE CASCADE,
CONSTRAINT account_fk_customerid foreign key (CustomerId) REFERENCES Customer_DML(customerId) ON DELETE CASCADE,
这两个示例更正应该可以帮助您解决其他语法错误。