Kbase P96676: SQL-92: Error 11005 when Altering TABLE name which Check Contrainst is defined
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/25/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
SYMPTOM(s):
Using JDBC or ODBC Client
Table is defined with check constraint
Ex: create table mytable ( a int, check( a > 10 ));
Any attempt to alter the Table name will result into the 11005
ex: alter table mytable rename to mytable1;
Cannot rename table/column with check constraint (11005)
CAUSE:
With the current ALTER TABLE implementation, this behavior is expected
FIX:
One solution is to load the contents of the related table into a temporary table, drop the table with Constraints, re-create a new Table with the new Table name then load the Data to the newly created table.