skip to main content
Querying data stores with SQL : Supported SQL and Extensions : Create Table for Salesforce
  

Try Now

Create Table for Salesforce

Purpose

Creates a new table in the 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