Functional Data Definition Language (FDDL)

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.