[teiid-issues] [JBoss JIRA] (TEIID-4784) Provide functionality to perform RENAME table in DDL scripts

[Bram Gadeyne (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13569645#comment-13569645 ] 

Bram Gadeyne edited comment on TEIID-4784 at 5/2/18 8:16 AM:
-------------------------------------------------------------

Hi, 

Nice to see that this feature will be included.

Is there already some documentation available? I'd like to test the 10.3 version. 

Does this allow the original tablename to contain the schema name?

E.g. 

{code:sql}
ALTER TABLE izisprod.P_GeneralData RENAME TO 'prod_P_GeneralData';
ALTER TABLE iziswh.P_GeneralData RENAME TO 'wh_P_GeneralData';
{code}

With izisprod and iziswh being the schema names.


was (Author: gadeyne.bram):
Hi, 

Nice to see that this feature will be included.

Is there already some documentation available? I'd like to test the 10.3 version. 

Does this allow the original tablename to contain the schema name?

E.g. 
ALTER TABLE izisprod.P_GeneralData RENAME TO 'prod_P_GeneralData';
ALTER TABLE iziswh.P_GeneralData RENAME TO 'wh_P_GeneralData';

With izisprod and iziswh being the schema names.

> Provide functionality to perform RENAME table in DDL scripts
> ------------------------------------------------------------
>
>                 Key: TEIID-4784
>                 URL: https://issues.jboss.org/browse/TEIID-4784
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 9.3
>            Reporter: Bram Gadeyne
>            Assignee: Ramesh Reddy
>              Labels: Beta3
>             Fix For: 10.0
>
>
> Allow rename commands like:
> ALTER TABLE "teiidtest" RENAME TO "tmptbl_teiidtest";
> This should rename the table name teiidtest in the current schema to tmptbl_teiidtest.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)