3.
Definition SQL
This chapter explains the syntax and structure of the definition SQL.
Organization of this chapter
General rules
ALTER INDEX (Alter index definition)
ALTER PROCEDURE (Re-create SQL object of procedure)
ALTER ROUTINE (Re-create SQL objects for functions, procedures, and triggers)
ALTER TABLE (Alter table definition)
ALTER TRIGGER (Re-create a trigger SQL object)
COMMENT (Comment)
CREATE AUDIT (Define the target audit event)
CREATE CONNECTION SECURITY (Define the connection security facility)
CREATE [PUBLIC] FUNCTION (Define function, define public function)
CREATE INDEX Format 1 (Define index)
CREATE INDEX Format 2 (Define index)
CREATE INDEX Format 3 (Define substructure index)
CREATE [PUBLIC] PROCEDURE (Define procedure, define public procedure)
CREATE SCHEMA (Define schema)
CREATE SEQUENCE (Define sequence generator)
CREATE TABLE (Define table)
CREATE TRIGGER (Define a trigger)
CREATE TYPE (Define type)
CREATE [PUBLIC] VIEW (Define view, define public view)
DROP AUDIT (Delete an audit target event)
DROP CONNECTION SECURITY (Delete the connection security facility)
DROP DATA TYPE (Delete user-defined data type)
DROP [PUBLIC] FUNCTION (Delete function, delete public function)
DROP INDEX (Delete index)
DROP [PUBLIC] PROCEDURE (Delete procedure, delete public procedure)
DROP SCHEMA (Delete schema)
DROP SEQUENCE (Delete sequence generator)
DROP TABLE (Delete table)
DROP TRIGGER (Delete a trigger)
DROP [PUBLIC] VIEW (Delete view table, delete public view table)
GRANT Format 1 (Grant privileges)
GRANT Format 2 (Change auditor's password)
REVOKE (Revoke privileges)