skip to main content

Embedded SQL Statements : CREATE

CREATE
The CREATE statement allows to create tables and indices.
General format
EXEC SQL [AT Database]
  CREATE Options
Syntax rules
1.
General Rules
1.
Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.
Examples
Create a table
exec sql
   create table customers
          (cust-code numeric(4) not null, 

Copyright (c) 2017 Veryant
Contact us
Please share your comments on this manual or on any
Veryant product documentation with the email button at the top left