Delete the content on the database?

DBNOOB · #1 (**permalink**) 11-05-04, 06:50

Hi @ll,

i want to delete the whole content of the database but not the structure.
How is this possible?

Thx @ll,

DBNOOB

J Petruk · #2 (**permalink**) 11-05-04, 08:49

Quote:

Originally Posted by DBNOOB

Hi @ll,

i want to delete the whole content of the database but not the structure.
How is this possible?

Thx @ll,

DBNOOB

Have to do it table by table, but that should be easy enough from a script.

An old trick - use LOAD with the REPLACE option from an empty file for each table, that avoids the logging of a DELETE.

J Petruk · #3 (**permalink**) 11-05-04, 08:50

Quote:

Originally Posted by J Petruk

Have to do it table by table, but that should be easy enough from a script.

An old trick - use LOAD with the REPLACE option from an empty file for each table, that avoids the logging of a DELETE.

Or you can use db2look with "-e -a" options to extract the structure as db2 statements, then create the database from scratch...

Internet Services

Web Development

Digital Marketing

Consumer Tech