Chapter 4 Connecting to the Repository


Dropping the Repository Tables

You can drop the tables of a repository database. If you are not connected to the repository, the Connect dialog box is displayed to let you identify the repository where you will drop the tables.

The Drop Repository Tables command removes all repository tables and their content from the database and interrupts the connection with the current database. You should be very careful when using this feature since you may lose all documents consolidated in the database.

WARNING! 

Caution
Drop Repository Database cannot be undone. In addition, you cannot drop the repository tables through a proxy connection. You must perform a direct ODBC connection instead.

Drop tables script

Drop statements appear first in the Repository Table Drop Script window. You can use this window to browse the statements.

If you need to modify the statements you have to copy the text, and paste it in a script interpreter. The Separator list lets you select the separator that corresponds to your interpreter. When you change separator using the Separator list, the script automatically displays this change.

You have to click Cancel in the Repository Table Drop Script window, then modify and execute the statements with your script interpreter.

WARNING! 

Read-only window
The Repository Table Drop Script window is read-only. You cannot edit any statement.

Steps To drop the repository tables:

  1. Select Repository→Drop Repository Tables to display the Repository Table Drop Script window.
  2. Click OK to confirm deletion.

 


Copyright (C) 2006. Sybase Inc. All rights reserved.