Thursday, March 01, 2007

Truncating tables in DB2

If you have a table full of data and want to just drop the lot you can truncate it, just as you can in Oracle. The command is:
db2= alter table [tablename] activate not logged initially with empty table

No comments: