rename views and schemes
Plannedthe names of views and schemes should be changeable with automatic adaption of other dependent views and procedures
-
Comment actionsOfficial comment
Hi Andreas,
this is also another feature that we have already in our roadmap and that was in the wish-list of other customers too.
Actually renaming a virtual schema is already possible. You can do it graphically in Data Virtuality Studio by right-clicking on the virtual schema name in the Data Explorer pane on the left side and select "Rename schema".
As an alternative, you can also call the "SYSADMIN.renameVirtualSchema()" stored procedure. Please, you can find more details in our reference guide:
https://datavirtuality.com/docs/#doc=Reference%20Guide&version=1.9&page=Virtual_Schemas.html
Renaming views and procedures is still missing but planned for one of the next major releases. Technically speaking, to implement this feature we need to extend our SQL syntax and to rework a big part of our code, in order to be sure that the changes are correctly propagated to all the other dependent objects (views, procedures, recommended optimizations, jobs, etc.).
As I mentioned already, we are going to release 2.1 quite soon and afterwards we will start planning other features like this one.
Best
Salvatore
Please sign in to leave a comment.
Comments
1 comment