15.10 - Delete All Objects in the Database - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

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.