skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Alter Table for Salesforce : Add Clause: Constraints
 

Try DataDirect Cloud Now
Add Clause: Constraints

Purpose

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)