Informix Guide to SQL: Syntax
Chapter 1: SQL Statements
Home
Contents
Index
Master Index
New Book
Categories of SQL Statements
SQL statements are divided into the following categories:
Access method statements
Auxiliary statements
Client/server connection statements
Cursor manipulation statements
Data access statements
Data definition statements
Data integrity statements
Data manipulation statements
Dynamic management statements
Query optimization information statements
Routine definition statements
SPL
statements
The specific statements for each category are listed below.
Access Method Statements
ALTER ACCESS_METHOD (
See the Virtual-Table Interface Programmer's Manual.)
CREATE ACCESS_METHOD (
See the
Virtual-Table Interface Programmer's Manual.)
CREATE OPCLASS
DROP ACCESS_METHOD
(See the
Virtual-Table Interface Programmer's Manual.)
DROP OPCLASS
Auxiliary Statements
INFO
OUTPUT
GET DIAGNOSTICS
WHENEVER
Client/Server Connection Statements
CONNECT
DISCONNECT
SET CONNECTION
Cursor Manipulation Statements
CLOSE
DECLARE
FETCH
FLUSH
FREE
OPEN
PUT
Data Access Statements
GRANT
GRANT FRAGMENT
LOCK TABLE
REVOKE
REVOKE FRAGMENT
SET ISOLATION
SET LOCK MODE
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
UNLOCK TABLE
Data Definition Statements
ALTER FRAGMENT
ALTER INDEX
ALTER TABLE
CLOSE DATABASE
CREATE CAST
CREATE DATABASE
CREATE DISTINCT TYPE
CREATE INDEX
CREATE OPAQUE TYPE
CREATE ROLE
CREATE ROW TYPE
CREATE SCHEMA
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DATABASE
DROP CAST
DROP DATABASE
DROP INDEX
DROP ROLE
DROP ROW TYPE
DROP SYNONYM
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
RENAME COLUMN
RENAME DATABASE
RENAME TABLE
Data Integrity Statements
BEGIN WORK
CHECK TABLE
COMMIT WORK
CREATE AUDIT
DROP AUDIT
RECOVER TABLE
REPAIR TABLE
ROLLBACK WORK
ROLLFORWARD DATABASE
SET
SET LOG
START DATABASE
START VIOLATIONS TABLE
STOP VIOLATIONS TABLE
Data Manipulation Statements
DELETE
INSERT
LOAD
SELECT
UNLOAD
UPDATE
Dynamic Management Statements
ALLOCATE COLLECTION
ALLOCATE DESCRIPTOR
ALLOCATE ROW
DEALLOCATE COLLECTION
DEALLOCATE DESCRIPTOR
DEALLOCATE ROW
DESCRIBE
EXECUTE
EXECUTE IMMEDIATE
FREE
GET DESCRIPTOR
PREPARE
SET DESCRIPTOR
Query Optimization Information Statements
SET EXPLAIN
SET OPTIMIZATION
SET PDQPRIORITY
UPDATE STATISTICS
Routine Definition Statements
CREATE FUNCTION
CREATE FUNCTION FROM
CREATE PROCEDURE
CREATE PROCEDURE FROM
CREATE ROUTINE FROM
DROP FUNCTION
DROP PROCEDURE
DROP ROUTINE
EXECUTE FUNCTION
EXECUTE PROCEDURE
SPL Statements
CALL
CONTINUE
DEFINE
EXIT
FOR
FOREACH
LET
ON EXCEPTION
RAISE EXCEPTION
RETURN
SET DEBUG FILE TO
SYSTEM
TRACE
WHILE
Informix Guide to SQL: Syntax
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.