Skip to main content

rename database

  • Oct 2, 2018 4:57 PM UTC
  • 3 replies
  • 21 views

sreedxc

how to rename database name of existing single or multinode database

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 6, 2018 1:50 PM UTC

gyoung
  • New Participant
  • Oct 16, 2018 2:04 AM UTC

t looks like @sreedxc wants to rename the db, not a view or table. I'm pretty sure we don't have a way to do that in enterprise Vertica, short of copying all the data to a newly named db. Eon mode has some different semantics for such -- check whether it can rename without moving data.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 16, 2018 3:08 PM UTC

@gyoung - Yes. @sreedxc asked the same question about renaming a database in the thread about renaming a view (the link I posted above). I answered his question in that thread :smile: