Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : Compliance with Industry Standards : SQL-92 DDL and DML statements
 

SQL-92 DDL and DML statements

The following table lists OpenEdge SQL DDL and DML Statements. A check mark identifies the compliance of each statement as SQL‑92, a level of ODBC SQL Grammar, or as a Progress extension.
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