SQL Statements and Extensions for the Salesforce Driver : Alter Table : Altering a Remote Table : Add Clause: Constraints

Add Clause: Constraints
Purpose
Use the Add clause to add a constraint to an existing table. It is optional.
This command adds a constraint using the same syntax as the Create Table command (see Column Definition for Remote Tables).
Syntax
ADD [CONSTRAINT constraint_name] ...
Notes
Example A
Assuming the current schema is 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)

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.