Delete All Objects in the Database - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities

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.