Statement
|
Use to ...
|
---|---|
ALTER TABLE expression;
|
add, drop, and modify
columns in a table
|
CREATE expression;
|
build new tables, views,
or indexes
|
DELETE expression;
|
eliminate unwanted rows
from a table or view
|
DESCRIBE expression;
|
display table and view
attributes
|
DROP expression;
|
eliminate entire tables,
views, or indexes
|
INSERT expression
|
add rows of data to
tables or views
|
RESET <option(s)>;
|
add to or change PROC
SQL options without re-invoking the procedure
|
UPDATE expression;
|
modify data values in
existing rows of a table or view
|