Drop Tables

 

The Database Navigator is able to drop existing tables. Dropping tables means that the table definition (including all data stored in the table) is immediately deleted. There is no way to bring the table or the content back, so be sure to check twice before dropping a table.

 

 

Select your table to drop

Select the table you want to drop in the Database Navigator. Then choose "Drop..." from the corner menu.

     
 

Drop the table

Before the table is actually dropped a dialog is displayed. Click on "Drop Now!" to immediatly delete the table and it's content. The table list is automatically refreshed after dropping the table.

If an error occurs (for instance if you do not have the necessary access privileges to drop the table) the Message Viewer displays the error message.

     

 

Rename Tables

 

The Database Navigator can issue a rename command on database servers that support table renaming. Table renaming is supported by Oracle, MySQL, PostgreSQL and many other database servers.

 

 

Select your table to rename

Select the table you want to rename with the Database Navigator. Then choose "Rename..." from the corner menu.

     
 

Rename the table

The rename dialog is displayed. Enter the new table name and click "Rename".

If an error occurs (for instance if you do not have the necessary access privileges to rename the table) the Message Viewer displays the error message.

     

 

Table renaming is not supported by MS SQL Server, OpenBase and Sybase. If you want to rename a table with these database servers you have to create a new table, copy the data and drop the existing table.