Progress
SQL-92
Guide and Reference
Statements, DDL and DML Syntax in BNF
This sections lists Progress SQL-92 Data Definition Language (DDL) and Data Manipulation Language (DML) statements in Backus-Naur Form (BNF).
ALTER USER Statement
BEGIN-END DECLARE SECTION
Host Language Type
CALL Statement
CLOSE Statement
COMMIT Statement
CONNECT Statement
CONNECT STRING Statement
CREATE INDEX Statement
CREATE PROCEDURE Statement
Parameter Declaration
CREATE SYNONYM Statement
CREATE TABLE Statement
Column Definition
Column Constraint
Tabel Constraint
CREATE TRIGGER Statement
CREATE USER Statement
CREATE VIEW Statement
DECLARE CURSOR Statement
DELETE Statement
DESCRIBE BIND VARIABLES Statement
DESCRIBE SELECT LIST Statement
DISCONNECT Statement
DROP INDEX Statement
DROP PROCEDURE Statement (ODBC Core SQL Grammar)
DROP SYNONYM Statement
DROP TABLE Statement
DROP TRIGGER Statement
DROP USER Statement
DROP VIEW Statement
EXEC SQL Statement
EXECUTE Statement
EXECUTE IMMEDIATE Statement
FETCH Statement
GET DIAGNOSTICS Statement
Header Info Item
GET DIAGNOSTICS EXCEPTION Syntax
Detail Info Item Syntax
GRANT RESOURCE, DBA Statement
GRANT PRIVILEGE Statement
PRIVILEGE
INSERT Statement
See also the Query Expressions Syntax in BNF.
LOCK TABLE Statement
OPEN Statement
PREPARE Statement
REVOKE RESOURCE, DBA Statement
REVOKE PRIVILEGE Statement
PRIVILEGE Syntax
ROLLBACK Statement
SELECT Statement
See also section Query Expressions Syntax in BNF.
SET CONNECTION Statement
SET SCHEMA Statement
SET TRANSACTION ISOLATION LEVEL Statement
ISOLATION LEVEL NAME
UPDATE Statement
ASSIGNMENT CLAUSE
UPDATE STATISTICS Statement
WHENEVER Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |