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.