The function
create-table
creates a table called
name
and defines its columns and other properties with
description
. The argument
description
is a list containing lists of attribute-name and type information pairs.
The default value of database is *default-database*.
(create-table [manager]
'(([id] (char 10) not-null)
([salary] (number 8 2))))
is equivalent to the following SQL:
CREATE TABLE MANAGER
(ID CHAR(10) NOT NULL,SALARY NUMBER(8,2))