× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Chandradip Jain
chandradipjain(*) reported 2014-02-14T12:40:42Z  · ivangron last modified 2014-02-20T20:53:47Z

For Amazon Redshift, Alter Schema option is missing.


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component DB - RedShift
Version Future
Aqua Data Studio 15.0.0-dev-110 
Build #: 36056
Built on: 2014-Feb-13 02:24:47 PM
OS Environment: Windows 8(x64 bit)
Database: Amazon Redshift
 
Alter Schema Option missing.
 
Steps to reproduce:
 
1. Connect to Amazon Redshift server,Select any database 
2. Create Schema
 
   CREATE SCHEMA "testredshift"
   GO
   
3. Right click on above created schema, here we observe alter schema option is missing.
4. As per Amazon Redshift Documentation we can Rename the schema or we can alter the owner of schema.
   Link: http://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_SCHEMA.html
5. so we go through Query analyzer, we run Alter schema scripts for Rename the schema or alter owner of schema and this will get executed successfully.
 
   Alter schema "testredshift"
   Rename to "redshift"
   GO
 
   
Please see attached screenshot.
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #11714
Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017