GBase SQL语法（五）

1.4 ANSI/ISO 的一致性和扩展

以下列表显示了在入门级别上符合 ANSI SQL-92 标准的语句、符合 ANSI 但包括 GBase 8s 扩展 的语句和 ANSI/ISO 标准的 GBase 8s 扩展语句。

符合 ANSI/ISO 的语句

• CLOSE

• COMMIT WORK

• RELEASE SAVEPOINT

• SET CONSTRAINTS（请参阅 SET Transaction Mode 语句）

• SET SESSION AUTHORIZATION

• SET TRANSACTION

具有 GBase 8s 扩展的符合 ANSI/ISO 的语句

• ALLOCATE DESCRIPTOR

• ALTER TABLE

• CONNECT

• COMMENT

• CREATE FUNCTION

• CREATE PROCEDURE

• CREATE TRIGGER

• CREATE SCHEMA

• CREATE TABLE

• CREATE TEMP TABLE

• CREATE VIEW

• DEALLOCATE DESCRIPTOR

• DECLARE

• DELETE

• DESCRIBE

• DESCRIBE INPUT

• DISCONNECT

• EXECUTE

• EXECUTE IMMEDIATE

• FETCH • GET DESCRIPTOR

• GET DIAGNOSTICS

• GRANT

• INSERT

• MERGE

• OPEN

• PREPARE

• REVOKE

• ROLLBACK WORK

• SAVEPOINT

• SELECT

• SET CONNECTION

• SET DESCRIPTOR

• UPDATE STATISTICS

• WHENEVER

ANSI/ISO 标准的扩展语句

• ALLOCATE COLLECTION

• ALLOCATE ROW

• ALTER ACCESS_METHOD

• ALTER FRAGMENT

• ALTER FUNCTION

• ALTER INDEX

• ALTER PROCEDURE

• ALTER ROUTINE

• ALTER SECURITY LABEL COMPONENT

• ALTER SEQUENCE

• ALTER TRUSTED CONTEXT

• ALTER USER • BEGIN WORK

• CLOSE DATABASE

• CREATE ACCESS_METHOD

• CREATE AGGREGATE

• CREATE CAST

• CREATE DATABASE

• CREATE DEFAULT USER

• CREATE DISTINCT TYPE

• CREATE EXTERNAL TABLE

• CREATE FUNCTION FROM

• CREATE INDEX

• CREATE OPAQUE TYPE

• CREATE OPCLASS

• CREATE PROCEDURE FROM

• CREATE ROLE

• CREATE ROUTINE FROM

• CREATE ROW TYPE

• CREATE SECURITY LABEL

• CREATE SECURITY LABEL COMPONENT

• CREATE SECURITY POLICY

• CREATE SEQUENCE

• CREATE SYNONYM

• CREATE TRUSTED CONTEXT

• CREATE USER

• CREATE XADATASOURCE

• CREATE XADATASOURCE TYPE

• DATABASE

• DEALLOCATE COLLECTION

• DEALLOCATE ROW

• DROP ACCESS_METHOD

• DROP AGGREGATE

• DROP CAST

• DROP DATABASE

• DROP FUNCTION

• DROP INDEX

• DROP OPCLASS

• DROP PROCEDURE

• DROP ROLE

• DROP ROUTINE

• DROP ROW TYPE

• DROP SECURITY LABEL

• DROP SECURITY LABEL COMPONENT

• DROP SECURITY POLICY

• DROP SEQUENCE

• DROP SYNONYM

• DROP TABLE

• DROP TRIGGER

• DROP TRUSTED CONTEXT

• DROP TYPE

• DROP USER

• DROP VIEW

• DROP XADATASOURCE

• DROP XADATASOURCE TYPE

• EXECUTE FUNCTION

• EXECUTE PROCEDURE

• FLUSH

• FREE

• GRANT FRAGMENT

• LOAD • LOCK TABLE

• OUTPUT

• PUT

• RELEASE SAVEPOINT

• RENAME COLUMN

• RENAME DATABASE

• RENAME INDEX

• RENAME SECURITY LABEL

• RENAME SECURITY LABEL COMPONENT

• RENAME SECURITY POLICY

• RENAME SEQUENCE

• RENAME TABLE

• RENAME TRUSTED CONTEXT

• RENAME USER

• REVOKE FRAGMENT

• SAVE EXTERNAL DIRECTIVES

• SET AUTOFREE

• SET COLLATION

• SET CONSTRAINTS （请参阅 SET Database Object Mode 语句）

• SET Database Object Mode

• SET DATASKIP

• SET DEBUG FILE TO

• SET DEFERRED_PREPARE

• SET ENCRYPTION PASSWORD

• SET ENVIRONMENT

• SET EXPLAIN

• SET INDEXES （请参阅 SET Database Object Mode 语句）

• SET ISOLATION

• SET LOCK MODE

• SET LOG

• SET OPTIMIZATION

• SET PDQPRIORITY

• SET ROLE

• SET STATEMENT CACHE

• SET TRIGGERS （请参阅 SET Database Object Mode 语句）

• SET USER PASSWORD

• START VIOLATIONS TABLE

• STOP VIOLATIONS TABLE

• TRUNCATE

• UNLOAD

• UNLOCK TABLE

• UPDATE STATISTICS