MuleSoft Connector for SASDataSets

Build 21.0.7940

CREATE TABLE Statements

To create new SAS Data Sets entities, use CREATE TABLE statements.

CREATE TABLE Syntax

The CREATE TABLE statement specifies the table name and a comma-separated list of column names and the primary keys of the table, as shown in the following example:

CREATE TABLE <table_name> [ IF [ NOT EXISTS ] ]
( 
  { 
     <column_name> <data_type> 
     [ NOT NULL ] 
     [ DEFAULT <literal> ] 
     [ PRIMARY KEY ] 
     [ UNIQUE ] 
  } |  PRIMARY KEY ( <column_name> [ , ... ] ) 
  [ , ... ]
)

The following example statement creates a MyCustomers table on the SAS Data Sets server with name, age, and address columns:

CREATE TABLE IF NOT EXISTS [MyCustomers] (name VARCHAR(20), age INT, address VARCHAR(20))

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7940