Notifications
Clear all

Macro to delete database schema contents?

4 Posts
4 Users
1 Reactions
2,089 Views
1
Topic starter

Hello,

Does anyone have a copy of the macro that deletes all the database schema contents?

Thanks!

Greg Merrill 2021-06-15 20:59:11

You want to empty the contents of tables, or actually drop the tables/indexes/procs/etc?

3 Answers
0
Topic starter

I think emptying the contents should do it.  My Bookstore project went sideways and I'm trying to recover.

0

If you just want to delete the data in your database, but preserve the schema; then one way to do that is to run the following in SQL:

{call dtb.delete_data()}

0

There is also the delete-data ant target that can be run from root:

ant delete-data