29 Informix Creating A Database Using Sql

Determining the Database Layout

Creating a Data Model

Implementing a Data Model

Creating a Database

Size Requirements

Chunks

Pages

Extents

dbspaces

Blobspaces

Root Dbspace

Size Requirement Considerations

Creating Tables

Constraint Limitations

Dropping and Adding Constraints

Defining a Unique Column

Defining a Primary and Foreign Key

Defining Check Constraints

Table Storage

Extent Option

Lock Mode Option

Temporary Tables

Temporary tables last for the time that your application program is processing or until your database is closed. A temporary table cannot have referential constraints placed on any defined columns nor can any column of the table be referenced from another table. If the user has connect privileges on the database, he can create a temporary table and build indexes on that temporary table.

When creating your tables, the only elements that are necessary are a unique table name within the database and unique column names within each table.

Creating Views

Altering Tables

ADD Clause

DROP Clause

MODIFY Clause

ADD CONSTRAINT Clause

DROP CONSTRAINT Clause

MODIFY NEXT SIZE Clause

LOCK MODE Clause

Creating Indexes

Altering Indexes

Privileges

Database-Level Privileges

Table-Level Privileges

Stored Procedures

Views

Integrity

Entity Integrity

Semantic Integrity

Referential Integrity

Bibliography

1. Creating a Database Using SQL