Notifications
Clear all

Macro to delete database schema contents?

   RSS

1
Topic starter

Hello,

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

Thanks!

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

2 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()}

© 2020 One Network Enterprises. All rights reserved. Privacy Policy