Deleting Tables and Table Objects

You can delete tables from Cview, as well as table objects such as keys, indexes, or check constraints.

To delete a table or tables from the database:

  1. Choose Tables in the left panel.
  2. Choose the table(s) you want to delete in the right panel.
  3. Click the Delete button in the right panel.

You can also delete an individual table as follows:

  1. Choose the table in the left panel.
  2. Do one of the following:

Deleting Indexes and Keys

To delete indexes or keys from the database:

  1. Click Indexes or Keys in the left panel.
  2. Choose the index(es) or key(s) you want to delete in the right panel.
  3. Click Delete.

You can also delete an individual index or key as follows:

  1. Choose the index or key in the left panel.
  2. Do one of the following:

Deleting Check Constraints

To delete check constraints from the database:

  1. Click Checks in the left panel.
  2. Choose the check constraint(s) you want to delete in the right panel.
  3. Click Delete.

You can also delete an individual check constraint as follows:

  1. Choose the check constraint in the left panel.
  2. Do one of the following: