SQL-92 DDL and DML statements

The following table lists OpenEdge SQL DDL and DML Statements. It displays "Yes" to identify the compliance of each statement as SQL-92, a level of ODBC SQL Grammar, or as a Progress extension.

Table 1. Compliance of SQL‑92 DDL and DML statements
OpenEdge SQL statement SQL‑92 ODBC SQLgrammar Progress extension Notes
ALTER USER — — Yes —
CALL — Extended — Must enclose in an ODBC escape clause { fn }
COMMIT Yes — — —
CONNECT Yes — USING password —
CREATE INDEX — Core AREA area_name —
CREATE PROCEDURE — Core Yes —
CREATE SYNONYM — — Yes —
CREATE TABLE Yes Minimum AREA AS query_expression —
CREATE TRIGGER — Core Yes —
CREATE USER — — Yes —
CREATE VIEW Yes Core — —
DELETE Yes Extended — —
DISCONNECT Yes — — —
DROP INDEX — Core — —
DROP PROCEDURE — Core Yes —
DROP SYNONYM — — Yes —
DROP TABLE — Minimum Yes —
DROP TRIGGER — — Yes —
DROP USER — — Yes —
DROP VIEW — Core Yes —
GRANT Yes Core INDEX RESOURCE DBA —
INSERT Yes Core — —
LOCK TABLE — — Yes —
REVOKE Yes Core INDEX RESOURCE DBA —
ROLLBACK Yes — — —
SELECT Yes Extended FOR UPDATE —
SET CONNECTION Yes — — —
SET SCHEMA Yes — — —
SET TRANSACTION ISOLATION LEVEL — — Yes —
UPDATE Yes Extended assignments of form:( column, column )= ( expr, expr ) —
UPDATE STATISTICS — — Yes —