Database Menu - Teradata Administrator

Teradata Administrator User Guide

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

Use the Database menu to indicate the type of information to display from the selected database. A check mark indicates the current setting of your database Default View option. That is, the information displayed when the database is double-clicked.

Note: The Database menu does not appear on the menu bar until a connection is established with a database server.


Table 4: Database Menu Commands 




Additional Information

List All Objects

Display each object in the selected database.

“Display All Objects” on page 93.

List Tables & Indexes

Display each table and index in the selected database.

“Display Tables and Indexes” on page 94.

List Views

Display each view in the selected database.

“Display Views” on page 95.

List Macros & Procedures

Display each macro, stored procedure in the selected database.

“Display Macros and Stored Procedures” on page 96.

List Databases & Users

Display all databases and users created under the selected database.

“Display Databases and Users” on page 96.

Database Information


Display information on the selected database.

“Display Database Information” on page 98.

Rights on DB/User


Display access rights for each table, view, and macro in the selected database.

“Display Rights on DB and User” on page 99.

Rights Held by DB/User


Display the access rights held by the selected database or user.

“Display Rights Held by DB and User” on page 100.

Role Memberships


Display role memberships assigned to the selected user.

“Display Role Memberships for the DB and User” on page 103.

Table Space

Display space usage for each table in the selected database.

“Display Table Space Usage” on page 104.

Child Space


Display space usage for each database that is owned directly by a selected database.

“Display Child Space Usage” on page 104.

Open/Close DB


Open to display or close to hide the children of the selected database node.

“Open or Close a Database in the Tree Display” on page 43.