skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Create Table for Salesforce
 

Try DataDirect Cloud Now

Create Table for Salesforce

Purpose

Supported only for Salesforce-based data stores. Creates a new table in the cloud data store.

Syntax

CREATE TABLE table_name (column_definition [, ...]
[, constraint_definition...])
where:
table_name
specifies the name of the new table. The table name can be qualified by a schema name using the format schema.table. If the schema is not specified, the table is created in the current schema.
column_definition
specifies the definition of a column in the new table.
constraint_definition
specifies constraints on the columns of the new table.

Notes

*Creating a table and its relationships can take several minutes.
* Column Definition
* Constraint Definition
* Foreign Key Clause