skip to main content
Supported SQL Statements and Extensions : Create Table : Creating a Remote Table
  

Try DataDirect Drivers Now

Creating a Remote Table

Purpose

Use the Create Table statement to create a new table. You can create either a remote or local table. A remote table is a Salesforce object and is exposed in the SFORCE schema. Creating a table in the SFORCE schema creates a remote table. A local table is maintained by the driver and is local to the machine on which the driver is running. A local table is exposed in the PUBLIC schema. Creating a table in the PUBLIC schema creates a local table.

Syntax

CREATE TABLE table_name (column_definition [, ...] [, constraint_definition...])
where:
table_name
specifies the name of the new remote 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. See "Alter Session (EXT)" for information about changing the current schema.
column_definition
specifies the definition of a column in the new table. See "Column Definition for Remote Tables" for a complete explanation.
constraint_definition
specifies constraints on the columns of the new table. See "Constraint Definition for Remote Tables" for a complete explanation.

Notes

*Creating tables in Salesforce is not a quick operation. It can take several minutes for Salesforce to create the table and its relationships.
* Column Definition for Remote Tables
* Constraint Definition for Remote Tables
* Foreign Key Clause