Delete All Objects in the Database - Teradata Administrator

Teradata Administrator User Guide

Teradata Administrator
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Delete All Objects in the Database

To delete all objects in the selected database

1 Click File>Drop to drop join or hash indexes defined on tables, as well as authorizations and UDTs.

2 Drop any journal table by issuing a MODIFY DATABASE <name> DROP DEFAULT JOURNAL TABLE statement from the Query window.

Note: All objects listed in Step 1 and journal tables must be dropped before proceeding to Step 3.

3 Select the database in the tree area.

4 Click File>Drop all Objects in DB.