Functional Data Definition Language (FDDL)


CLSQL provides a functional DDL which supports the creation and destruction of a variety of database objects including tables, views, indexes and sequences. Functions which return information about currently defined database objects are also provided. In addition, the FDDL includes functionality for examining table attributes and attribute types.

Table of Contents

CREATE-TABLE — Create a database table.
DROP-TABLE — Drop a database table.
LIST-TABLES — Returns a list of database tables.
TABLE-EXISTS-P — Tests for the existence of a database table.
CREATE-VIEW — Create a database view.
DROP-VIEW — Drops a database view.
LIST-VIEWS — Returns a list of database views.
VIEW-EXISTS-P — Tests for the existence of a database view.
CREATE-INDEX — Create a database index.
DROP-INDEX — Drop a database index.
LIST-INDEXES — Returns a list of database indexes.
INDEX-EXISTS-P — Tests for the existence of a database index.
ATTRIBUTE-TYPE — Returns the type of the supplied attribute.
LIST-ATTRIBUTE-TYPES — Returns information about the attribute types of a table.
LIST-ATTRIBUTES — Returns the attributes of a table as a list.
CREATE-SEQUENCE — Create a database sequence.
DROP-SEQUENCE — Drop a database sequence.
LIST-SEQUENCES — Returns a list of database sequences.
SEQUENCE-EXISTS-P — Tests for the existence of a database sequence.
SEQUENCE-LAST — Return the last element in a database sequence.
SEQUENCE-NEXT — Increment the value of a database sequence.
SET-SEQUENCE-POSITION — Sets the position of a database sequence.
TRUNCATE-DATABASE — Drop all tables, views, indexes and sequences in a database.