i在PostgreSQL中创建表。然后,我不得不将列用作外键,因此我更改了表以将该列定义为外键。但是我在"WITH"
,
ALTER TABLE Account WITH NOCHECK ADD CONSTRAINT FK_Account_AccountCPCMapping FOREIGN KEY(nAccountCPCMappingID)
REFERENCES AccountCPCMapping (nAccountCPCMappingID);
我遇到的错误,
ERROR: syntax error at or near "WITH"
LINE 1: ALTER TABLE Account WITH NOCHECK ADD CONSTRAINT FK_Account...
请建议任何更正。
您尝试使用Microsoft SQL Server语法https://learn.microsoft.com/en-us/sql/t-sql/st-sql/statement/alter-table-table-transact-transact-sql
postgres语法https://www.postgresql.org/docs/current/static/sql-altertable.html是
...ADD table_constraint [ NOT VALID ]