How to Add constraints foreign key in LibreOffice Base

[mbolanosd]

In SQL I use ALTER TABLE to ADD CONSTRAINTS, but the syntax from SQL keeps giving errors and most time the table is declared as non-existent when it exists.

Example: ALTER TABLE address
ADD CONSTRAINT fk_address_city FOREIGN KEY (city_id) REFERENCES city (city_id) ON UPDATE CASCADE;

Table address does not exists, but it does exists.

[mbolanosd]

Finally worked… LibreOffice BAse SQL requires " and not ’ to enclose tables. fields, and keys.