Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio 15.0.0-dev-256
Build #: 37570
Built on: 2014-Apr-28 05:22:50 PM
Operating system:Windows 7 x64
Database:Vertica 7
Right click on any created table
Select script object to window as->Alter
Here alter table script for adding column is provided but Alter table script for renaming table name is not provided
Alter table script for renaming table name:
ALTER TABLE [[db-name.]schema.]table-name [ , ... ]... RENAME [TO] new-table-name [ , ... ]
@Ivan: For Table -> Script Object to Window-> Alter can you have the below template
In alter table script can we have below script also:
ALTER TABLE [[db-name.]schema.]table-name [ , ... ]... RENAME [TO] new-table-name [ , ... ]
Alter table script for adding & renaming column is provided but same for renaming table name is not provided
In alter table script can we have below script also:
ALTER TABLE [[db-name.]schema.]table-name [ , ... ]... RENAME [TO] new-table-name [ , ... ]
Alter table script for adding & renaming column is provided but same for renaming table name is not provided
I've created a new issue for this feature request, but as a general request to enhance the ALTER script with add/drop/rename for all databases. (12301)
I've created a new issue for this feature request, but as a general request to enhance the ALTER script with add/drop/rename for all databases. (12301)
Verified in dev-334.Works fine
Verified in dev-334.Works fine
Issue #11979 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #12301
Issue #12301Enhance ALTER TABLE scripting to include add/drop/rename columns |
@Ivan: For Table -> Script Object to Window-> Alter can you have the below template