[ 
https://issues.apache.org/jira/browse/DERBY-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785110#action_12785110
 ] 

Dag H. Wanvik commented on DERBY-3605:
--------------------------------------

I'd be ok just removing this sentence. But either way is fine with me. +1


> Remove restriction "If there is an index defined on the table, the table can 
> be renamed."
> -----------------------------------------------------------------------------------------
>
>                 Key: DERBY-3605
>                 URL: https://issues.apache.org/jira/browse/DERBY-3605
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.3.2.1
>         Environment: N/A
>            Reporter: Oleksandr Alesinskyy
>
> Remove following restriction for "RENAME TABLE" statement:
> "If there is an index defined on the table, the table can be renamed."
> I really do not see any valid reasons (except, probably not very wise 
> implementation) for existence this restriction. And it may come  very 
> inconvinient if table to be renamed has an index(ses) referenced by foreign 
> keys from other tables.
> Regards,
> Oleksandr

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to