CREATE DRAWING Statement

Creates a new table.

 

Syntax

 

CREATE DRAWING drawing [(column type [(size)] [DEFAULT default] [, column type [(size)] ...])]

 

The CREATE DRAWING statement has these parts:

 

Part

Description

drawing

The name of the drawing to be created.

column

The name of the column or columns to be created in the table bound to the new drawing, in addition to the ID column and intrinsic columns.

type

The data type of the column in the table bound to the new drawing.

size

The column size in characters or bytes for text or binary columns.

default

The expression defining the default value of column in the table bound to the new drawing. Can contain literal values, and functions of these values.

 

Remarks

 

Use the CREATE DRAWING statement to define a new drawing. The CREATE DRAWING statement is similar to the CREATE TABLE statement, except that it creates a drawing together with the ID column and the intrinsic columns, and does not require supplying extra columns. All text columns are created as Unicode text type columns.

 

The CREATE DRAWING statement is an action query and cannot be used from within the ODBC driver.

 

To define a new table not bound to a drawing, use the CREATE TABLE statement.

 

Examples

 

This example creates a new drawing called "This Drawing" with only the ID column and intrinsic columns:

 

CREATE DRAWING [This Drawing];

 

This example creates a new drawing called "This Drawing" with the ID column, intrinsic columns and an integer column:

 

CREATE DRAWING [This Drawing] ([Population] INTEGER);