SQL-92 DDL and DML statements

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