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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reopened TEIID-4784:
-----------------------------------


> Is there already some documentation available?

It looks like it is only covered in the generated parser doc - http://teiid.github.io/teiid-documents/master/content/reference/BNF_for_SQL_Grammar.html#alterRenameTable

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

Yes that should be allowable.

However it doesn't appear that this implementation is complete as it leaves the schema reference to the table unchanged, which means that it will not resolve properly.  I'm reopening this based upon that observation.

> 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)