SQL Statements and Extensions for the Salesforce Driver : Create Table : Creating a Remote Table : Constraint Definition for Remote Tables

Constraint Definition for Remote Tables
Purpose
Defines the syntax to define a contraint for a remote table.
Syntax
[CONSTRAINT [constraint_name]
{foreign_key_constraint}]
where:
constraint_name
Is ignored. The driver uses the Salesforce relationship naming convention to generate the constraint name.
foreign_key_constraint
Defines a link between related tables. See Foreign Key Clause for syntax.
A column defined as a foreign key in one table references a primary key in the related table. Only values that are valid in the primary key are valid in the foreign key. The following example is valid because the foreign key values of the dept id column in the EMP table match those of the id column in the referenced table DEPT:
The following example, however, is not valid. The value 4 in the dept id column does not match any value in the referenced id column of the DEPT table.

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