Release 10.1A: OpenEdge Data Management:
SQL Development

> ## Online schema changes

> The following commands can be executed against an online database:

> - `ALTER TABLE ADD COLUMN`

> - `CREATE INDEX`

> Note: Inactive indexes can be 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`.

> - `CREATE SEQUENCE`

> - `CREATE STORED PROCEDURE`

> - `CREATE TABLE`

> - `CREATE TRIGGER`

> - `CREATE VIEW`

> - `GRANT`

> For syntax and specific information about each command, see OpenEdge Data Management: SQL Reference .

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095