Erasing all data from table
- Details
- Category: DB2 LUW Tips & Tricks
- Published: Thursday, 28 April 2016 22:46
- Written by Super User
- Hits: 2399
When you need to remove all data from a table in DB2 on LUW you have four choices depending on whether or not you want it logged or not.
These methods are all good methods but are only valid for either certain types of tables or situations. It is the DBA's and/or Developer's task to choose the correct method in their applications and work.