Kbase P96692: SQL-92: Is Alter table add column with a constraint supported when used in a Online Schema change?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/25/2004 |
|
Status: Unverified
GOAL:
Using JDBC or ODBC Client
GOAL:
Using ALTER TABLE ADD COLUMN which the COLUMN has a constraint
GOAL:
Using Online Schema Change feature
GOAL:
Is the ALTER TABLE ADD COLUMN supported in this scenario?
FACT(s) (Environment):
OpenEdge 10.0x
FIX:
No, with the current ALTER TABLE implementation, it is not supported to alter table by adding new column with constraint while the Database is in use (by using Online Schema Change)