HP 3000 Manuals

ALLBASE/ISQL Reference Manual

Creating Objects 

You can use ISQL to create database objects such as tables, views, and
indexes.  To do this, you use the SQL CREATE statements, as in the
following example:

     isql=> CREATE TABLE MyTable (col1 smallint, col2 char(10)) in MyFS; 

     A table named MyTable is created with two columns: The first column
     can contain integer data and the second character data.  The table is
     stored in MyFS. 

Statements used to create and redefine objects in the database are
collectively referred to as data definition language (DDL) statements.
Refer to the "SQL Statements" chapter of the ALLBASE/SQL Reference Manual 
for complete information on using the following SQL CREATE statements:

     CREATE DBEFILE
     CREATE DBEFILESET
     CREATE TABLE
     CREATE VIEW
     CREATE INDEX
     CREATE GROUP
     CREATE TEMPSPACE

You can also remove objects from a DBEnvironment through ISQL using the
following SQL DROP statements:

     DROP DBEFILE
     DROP DBEFILESET
     DROP TABLE
     DROP VIEW
     DROP INDEX
     DROP GROUP
     DROP MODULE
     DROP TEMPSPACE

Refer to the "SQL Statements" chapter of the ALLBASE/SQL Reference Manual 
for complete information on using these DROP statements.

For complete information on configuring a new DBEnvironment, refer to the
chapters on "DBEnvironment Configuration and Security" and "Database
Creation and Security" in the ALLBASE/SQL Database Administration Guide.

MPE/iX 5.0 Documentation