Supported only for Salesforce-based data stores. Adds a constraint to an existing table. This clause is optional.
Syntax
ADD [CONSTRAINT constraint_name] ...
Notes
The only type of constraint you can add is a foreign key constraint.
When adding a foreign key constraint, the table that contains the foreign key must be empty.
Example
Assuming a schema named SFORCE, a foreign key constraint is added to the deptId column of the test table, referencing the rowId of the dept table. For the operation to succeed, the dept table must be empty.
ALTER TABLE test ADD FOREIGN KEY (deptId) REFERENCES dept(rowId)