Informix Guide to SQL: Syntax
Chapter 1: SQL Statements
Home
Contents
Index
Master Index
New Book
SQL Statements
How to Enter SQL Statements
How to Enter SQL Comments
Categories of SQL Statements
ANSI Compliance and Extensions
Statements
ALLOCATE COLLECTION
ALLOCATE DESCRIPTOR
ALLOCATE ROW
ALTER FRAGMENT
ALTER INDEX
ALTER TABLE
BEGIN WORK
CLOSE
CLOSE DATABASE
COMMIT WORK
CONNECT
CREATE CAST
CREATE DATABASE
CREATE DISTINCT TYPE
CREATE FUNCTION
CREATE FUNCTION FROM
CREATE INDEX
CREATE OPAQUE TYPE
CREATE OPCLASS
CREATE PROCEDURE
CREATE PROCEDURE FROM
CREATE ROLE
CREATE ROUTINE FROM
CREATE ROW TYPE
CREATE SCHEMA
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DATABASE
DEALLOCATE COLLECTION
DEALLOCATE DESCRIPTOR
DEALLOCATE ROW
DECLARE
DELETE
DESCRIBE
DISCONNECT
DROP CAST
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP OPCLASS
DROP PROCEDURE
DROP ROLE
DROP ROUTINE
DROP ROW TYPE
DROP SYNONYM
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
EXECUTE
EXECUTE FUNCTION
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
FLUSH
FREE
GET DESCRIPTOR
GET DIAGNOSTICS
GRANT
GRANT FRAGMENT
INFO
INSERT
LOAD
LOCK TABLE
OPEN
OUTPUT
PREPARE
PUT
RENAME COLUMN
RENAME DATABASE
RENAME TABLE
REVOKE
REVOKE FRAGMENT
ROLLBACK WORK
SELECT
SET
SET AUTOFREE
SET CONNECTION
SET DATASKIP
SET DEBUG FILE TO
SET DEFERRED_PREPARE
SET DESCRIPTOR
SET EXPLAIN
SET ISOLATION
SET LOCK MODE
SET LOG
SET OPTIMIZATION
SET PDQPRIORITY
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
START VIOLATIONS TABLE
STOP VIOLATIONS TABLE
UNLOAD
UNLOCK TABLE
UPDATE
UPDATE STATISTICS
WHENEVER
Segments
Argument
Collection Derived Table
Condition
Constraint Name
Database Name
Data Type
DATETIME Field Qualifier
Expression
External Routine Reference
Function Name
Identifier
Index Name
INTERVAL Field Qualifier
Literal Collection
Literal DATETIME
Literal INTERVAL
Literal Number
Literal Row
Procedure Name
Quoted Pathname
Quoted String
Relational Operator
Return Clause
Routine Modifier
Routine Parameter List
Specific Name
Statement Block
Synonym Name
Table Name
View Name
Informix Guide to SQL: Syntax
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
