Kbase P66331: Can I add fields to a table that already exists during the Database is online?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/6/2004 |
|
Status: Unverified
GOAL:
Can I add fields to a table that already exists during the Database is online?
GOAL:
Can I add a table during the Database is online?
GOAL:
Can I add an index during the Database is online?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
Version 10 has part 3 of the ongoing online schema change project.
It allows you to do the following online:
0. Create a new table from 4GL dictionary
1. Create a new index for a new table from 4GL dictionary
2. Create new sequence generators from 4GL dictionary
3. SQL ALTER TABLE RENAME ...
4. SQL CREATE TABLE ...