Summary

Important: Clearing one or more tables permanently deletes those records from the PayGlobal database. Always backup data before attempting this procedure.

You may need to delete a number of records in your database. Rather than individually deleting those records from the grid, you can use the Clear Tables tool to delete all records in a table at one time.

Important: Before you run the Manage Tables command, you must turn off Referential Integrity. If Referential Integrity is not turned off, then PayGlobal cannot remove any records that are referenced. After you run the Manage Tables command, you should run the Check Database Integrity command.

When to use

Use the Clear Tables tool:

• After parallel testing but immediately before going live.
• To compact the database. A good example of how to use the Clear Tables tool effectively is to use it to remove all records from the message table.

Procedure

To clear tables:

1. Backup your database.
2. Double-click the Manage Tables command to reach the Manage Tables window.
3. Tag the entities that you want to clear tables for.
4. From the main menu, select Tools | Clear Tables.
5. The following Confirm message is displayed:

   Are you sure you want to clear these tables?

6. Click 'Yes' to continue or 'No' to cancel.

Limited to Supervisors

The Clear Tables command is usually limited to supervisors or others with a high security clearance. It displays a list of all data tables available in PayGlobal.

See also

Manage Tables