Link to this page
Print this page
Parent topic
:
SQL support
SQL support
Static SQL statements
Understanding static SQL statements
Using program variables in static SQL
Table and column names in static SQL
SQL texts generated by the compiler
INSERT
Creates a new row in a database table.
UPDATE
Modifies rows of a database table.
DELETE
Removes rows from a database table.
SELECT
Produces a result set from a query on database tables.
SQL ... END SQL
Performs an SQL that is not part of the static SQL syntax.
CREATE SEQUENCE
Creates a new sequence object in the database.
ALTER SEQUENCE
Modifies the definition of an existing sequence in the database.
DROP SEQUENCE
Drops a sequence object from the database.
CREATE TABLE
Creates a new table object in the database.
ALTER TABLE
Modifies the definition of an existing table in the database.
DROP TABLE
Drops a table object from the database.
CREATE INDEX
Creates a new index object in the database.
ALTER INDEX
Modifies the definition of an existing index in the database.
DROP INDEX
Drops an index object from the database.
CREATE VIEW
Creates a new view object in the database.
DROP VIEW
Drops a view object from the database.
CREATE SYNONYM
Creates a new synonym object in the database.
DROP SYNONYM
Drops a synonym object from the database.
RENAME
Renames an object in the database.