Rename Schema

Moderator: NorbertKrupa

Post Reply
User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Rename Schema

Post by usli06 » Thu Jun 21, 2012 6:34 pm

Hi all,

Is there some way that I can rename a schema?

Thanks!
Top
jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:
Contact jpcavanaugh

Re: Rename Schema

Post by jpcavanaugh » Thu Jun 21, 2012 7:06 pm

alter schema x rename to y;

http://my.vertica.com/docs/6.0.0-1/HTML ... #12052.htm
Top
User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Re: Rename Schema

Post by usli06 » Sat Jun 23, 2012 3:26 am

Thanks, foo! I knew we could do that with tables, but not schemas :oops:
Top
Post Reply

Return to “New to Vertica Database Administration”