Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements
 

OpenEdge SQL Statements

This section provides detailed information on OpenEdge® SQL statements. A description for each statement provides the following information:
*A definition of the statement
*The syntax of the statement's proper usage
*A code sample that shows how the statement works
*Any associated notes
*Authorization required in order to run the statement
*Related statements
OpenEdge SQL does not support retrying a statement after it fails. OpenEdge SQL architecture cannot continue reliable execution after an error occurs during statement execution. You should close the failing statement and execute again.
* ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'
* ALTER DATABASE SET PRO_ENABLE_64BIT_SEQUENCES 'Y'
* ALTER GROUP
* ALTER SEQUENCE
* ALTER TABLE
* ALTER TENANT
* ALTER USER
* AUDIT INSERT
* AUDIT SET
* CALL
* Column constraints
* COMMIT
* CONNECT AS CATALOG
* CREATE DOMAIN
* CREATE GROUP
* CREATE INDEX
* CREATE PROCEDURE
* CREATE SEQUENCE
* CREATE SUPER-TENANT
* CREATE SYNONYM
* CREATE TABLE
* CREATE TENANT
* CREATE TRIGGER
* CREATE USER
* CREATE VIEW
* DELETE
* DISCONNECT CATALOG
* DROP DOMAIN
* DROP GROUP
* DROP INDEX
* DROP PROCEDURE
* DROP SEQUENCE
* DROP SYNONYM
* DROP TABLE
* DROP TENANT
* DROP TRIGGER
* DROP USER
* DROP VIEW
* GRANT
* INSERT
* LOCK TABLE
* REVOKE
* ROLLBACK
* SELECT
* SET CATALOG
* SET PRO_CONNECT LOG
* SET PRO_CONNECT QUERY_TIMEOUT
* SET PRO_SERVER QUERY_TIMEOUT
* SET PRO_SERVER LOG
* SET ROWCOUNT
* SET SCHEMA
* SET TRANSACTION ISOLATION LEVEL
* SHOW CATALOGS
* SHOW GROUP
* SHOW PARTITION
* SHOW ROWCOUNT
* SHOW TENANT
* SHOW ENCRYPT ON
* Table constraints
* UPDATE
* UPDATE STATISTICS