The following commands can be executed against an online database:
ALTER TABLE ADD COLUMN
Note: The ALTER TABLE command for adding a LOB column is also an online operation. The ALTER TABLE command for dropping a LOB column is an offline operation. For further information, see OpenEdge Data Management: SQL Reference.
ALTER TABLE ALTER COLUMN
ALTER TABLE ADD PARTITION
ALTER TABLE ALTER INDEX
ALTER TABLE DROP PARTITION
ALTER TABLE PREPARE FOR SPLIT
Note: The ALTER TABLE command for splitting a composite partition (SPLIT PRO_INITIAL) and splitting a RANGE partition is also an online operation. For further information, see OpenEdge Data Management: SQL Reference.
CREATE INDEX
Note: Inactive indexes can be created online. Local and global (inactive) indexes are also created online. Active indexes can only be created online if they are created on a newly created table within the same transaction as the CREATE TABLE. For further information, see OpenEdge Data Management: SQL Reference.
CREATE SEQUENCE
CREATE STORED PROCEDURE
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DROP PROCEDURE
Note: For databases enabled for OpenEdge Replication, the DROP PROCEDURE statement is an offline operation. For further information, see OpenEdge Data Management: SQL Reference.
DROP SYNONYM
DROP TABLE
Note: The DROP TABLE statement is an online operation only in certain cases. For further information, see OpenEdge Data Management: SQL Reference.
DROP VIEW
GRANT
REVOKE
SET ENCRYPT
SET DECRYPT
SET BUFFER_POOL
For syntax and specific information about each command, see OpenEdge Data Management: SQL Reference.
ALTER TABLE ADD COLUMN