Progress/400
Product Guide


Deleting a Table

The Progress/400 Data Dictionary allows you to delete a table in the server schema. It also gives you the option of deleting the associated DB2/400 physical file. If you choose to delete the table only from the server schema, you can still access the associated database file through non-Progress AS/400 applications. However, if you choose to delete the physical file, no application can access it. When you delete a physical file, any logical files associated with it are deleted, regardless of whether other physical files refer to the logical files. For example, if a join logical file refers to the Customer and Order tables, and you delete the Order table and do not preserve the DB2/400 physical file, the join logical file is deleted also.

Virtual files are an exception. The Progress/400 Data Dictionary allows you to delete these from the server schema. However, it does not allow you to delete the associated DB2/400 logical files.

Follow these steps to delete a table:

  1. Choose the Table mode button in the Progress/400 Data Dictionary main window.
  2. Choose Modify schema.
  3. Select a table from the Tables list.
  4. Choose the Delete Table button. The following message appears:
  5. Choose Yes.
  6. A message appears asking you whether you want to delete the DB2/400 physical file.
  7. Choose Yes to delete the physical file, or choose No to delete the definition from the server schema only and preserve the DB2/400 physical file.
  8. You modified the data definitions in the server schema on the AS/400. Your server schema now has changes that are not reflected in the client schema holder until you synchronize it.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095