ALLBASE/SQL Reference Manual (36216-90216)

284 Chapter10
SQL Statements A - D
SQL Statement Summary
Tables ALTER TABLE Adds to a table new columns and
constraints, or drops constraints
from a table, and assigns a table to a
partition or removes it from a
partition.
RENAME COLUMN Defines a new name for an existing
column.
RENAME TABLE Defines a new name for an existing
table.
CREATE TABLE Defines a table and assigns it to a
partition.
TRUNCATE TABLE Deletes all rows from a table.
DROP TABLE Deletes a table and any authorities,
indexes, rules, and views based on
it.
Views CREATE VIEW Defines a view based on a table,
another view, or a combination of
tables and views.
DROP VIEW Deletes the definition of a view as
well as authorities or views based
on the view.
Rules CREATE RULE Defines a rule for a table and
associates it with INSERTS,
UPDATES, and/or DELETES.
DROP RULE Deletes a rule.
Groups,
DBEFileSet,
DBEFiles
Refer to the database
administration
statements.
Procedures CREATE PROCEDURE Defines a procedure for storage in
the DBEnvironment.
DROP PROCEDURE Deletes a procedure.
Partitions CREATE PARTITION Defines a partition for audit logging
in the DBEnvironment.
DROP PARTITION Deletes a partition.
Data manipulation
DELETE Deletes one or more rows from a
single table or view.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use