Function

Summary

Creates an index for a table.

Package

sql

Signature

create-index name &key on unique attributes database =>

Arguments

name

The name of the index.

on

The name of a table.

unique

A boolean.

attributes

A list of attributes.

database

A database.

Values

None.

Description

The function create-index creates an index called name on the table specified by on . The attributes of the table to index are given by attributes . Setting unique to t includes UNIQUE in the SQL index command, specifying that the columns indexed must contain unique values.

The default value of unique is nil . The default value of database is *default-database*.

Example

(create-index [manager]

   :on [emp] :unique t :attributes '([ename] [sal]))

See also

*default-database*
drop-index
create-table