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