Kbase P65436: ALTER TABLE - OpenEdge 10 SQL92 Statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
What is the additional support for ALTER TABLE in OpenEdge 10
GOAL:
ALTER TABLE statement (SQL-92)
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
Starting with the Service Pack 9.1D05, we have support for the following options of ALTER TABLE
ALTER TABLE [owner].table_name ADD column (column_name data_type)
ALTER TABLE [owner].table_name RENAME column column_name TO column_name
ALTER TABLE [owner].table_name RENAME TO table_name
Within OpenEdge 10, we have the additional following option:
ALTER TABLE [owner].table_name ADD column <column_definition>