Deleting All records of a DB table - Forum - OpenEdge General - Progress Community

Deleting All records of a DB table

 Forum

Deleting All records of a DB table

  • Is there any way to delete the All records of a DB table which is something similar to EMPTY temp table?

    I could not find any such method/statement.

    I would appreciate response if anyone have tried any way, basically I want to delete all records from few of the tables.

  • DELETE FROM .

  • Hello Mike,

    Thank you for your prompt response.

    Does it have the same impact in terms of growing size as the Normal "for each

    :.... Delete . End". have?

  • Yes it will cause the BI file to grow.

    It's still better than the FOR EACH as it does not require an ABL loop and so will be (slightly) faster. The fastest way is to drop the table and reload it. Using DDL. But that requires a schema lock and so is not suitable for runtime.

  • Thanks Mike.

  • If this is a recurring requirement, rather than a one-time deal, you might consider putting this table in its own database.  Then you can "empty" the table simply by deleting the existing database and copying in an embty copy.

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • Thanks.