Dropping a Database

This tool drops an existing database. Only the Database Administrator is allowed to drop a database.

  1. Stop the database.
  2. On the Configuration Menu, click Drop Database and then click OK.
  3. Select the database to drop and click OK.
  4. Click Yes to confirm that you want to drop the database.
  5. Type yes and click OK to reconfirm that you really want to drop the database.
  6. A message indicates that you have successfully dropped the database. Click OK.

When Vertica drops the database, it also automatically drops the node definitions that refer to the database . The following exceptions apply: