ALTER TABLE ADD CONSTRAINT is ignored

[s13o]

At the export of schema from Spanner web console some FK could be exported by a separate ALTER TABLE instructions like

ALTER TABLE ASSESSMENT ADD CONSTRAINT FK_ASSESSMENT_ACTIVITY FOREIGN KEY(CARE_ACTIVITY_ID) REFERENCES CARE_ACTIVITY(CARE_ACTIVITY_ID);

Such FK-constraints are completely skipped. It is not comfortable. I have to review and manually edit the DDL script to fix it. It could be dozens of such constraints in DDL export.

[nktks]

Sorry, this library assumed only create statements.
Because we use only create statements by using https://github.com/daichirata/hammer

[s13o]

Oh, really? Thanks, never know such a tool exists. I've used the schema file exported from the spanner web console only and it has a number of "alter" instructions in my case.
I promise you to validate my schema with "Hammer" and will let you know the results. Probably we will close the use then or/and will document a workaround with "Hammer".