Deleting all rows from a table

April 6, 2011
 |  No Comments
 |  Category: Database

heres how to delete the contents of an entire table in DB2

db2 import from /dev/null of del commitcount 1000 replace into 'tablename'

 |  Tags: