Kbase P83293: What is the fastest way to delete a table and its data while other users are in the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/16/2010 |
|
Status: Verified
GOAL:
What is the fastest way to delete a table and its data while other users are in the database?
GOAL:
Can a table be deleted while others users are in the database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
A database table definition can not be deleted while others are in the database. The following explains how to delete the data and then the table.
To delete the data while other users are in the database do:
FOR EACH <table name> EXCLUSIVE-LOCK:
DELETE <table name>.
END.
This will delete all the data. Then when the database can be shut down, the dictionary can be used to finally delete the table and associated objects. This will allow for the least amount of database downtime.