Function

Summary

Creates a table.

Package

sql

Signature

create-table name description &key database =>

Arguments

name

The name of the table.

description

The table properties.

database

A database.

Values

None.

Description

The create-table function 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* .

Example

The following code:

(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))

See also

drop-table