3.
Definition SQL
This chapter explains the syntax and structure of the definition SQL.
Organization of this chapter
General rules
ALTER PROCEDURE (Recreate SQL object of procedure)
ALTER ROUTINE (Recreate SQL objects for functions, procedures, and triggers)
ALTER TABLE (Alter table definition)
ALTER TRIGGER (Recreate a trigger SQL object)
COMMENT (Comment)
CREATE ALIAS (Define alias)
CREATE AUDIT (Define the target audit event)
CREATE CONNECTION SECURITY (Define the connection security facility)
CREATE FOREIGN INDEX (Define a foreign index)
CREATE FOREIGN TABLE (Define a foreign table)
CREATE FUNCTION (Define function)
CREATE INDEX Format 1 (Define index)
CREATE INDEX Format 2 (Define index)
CREATE PROCEDURE (Define procedure)
CREATE SCHEMA (Define schema)
CREATE SERVER (Define a foreign server)
CREATE TABLE (Define table)
CREATE TRIGGER (Define a trigger)
CREATE TYPE (Define type)
CREATE USER MAPPING (Define user mapping)
CREATE VIEW (Define view)
DROP ALIAS (Delete alias)
DROP AUDIT (Delete an audit target event)
DROP CONNECTION SECURITY (Delete the connection security facility)
DROP DATA TYPE (Delete user-defined data type)
DROP FOREIGN INDEX (Delete a foreign index)
DROP FOREIGN TABLE (Delete a foreign table)
DROP FUNCTION (Delete function)
DROP INDEX (Delete index)
DROP PROCEDURE (Delete procedure)
DROP SCHEMA (Delete schema)
DROP SERVER (Delete a foreign server)
DROP TABLE (Delete table)
DROP TRIGGER (Delete a trigger)
DROP USER MAPPING (Delete user mapping)
DROP VIEW (Delete view table)
GRANT Format 1 (Grant privileges)
GRANT Format 2 (Change auditor's password)
REVOKE (Revoke privileges)