15.10 - Database Menu - Teradata Administrator

Teradata Administrator User Guide

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

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 

Command

Button

Description

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

None

Display information on the selected database.

“Display Database Information” on page 98.

Rights on DB/User

None

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

None

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

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

Role Memberships

None

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

None

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

“Display Child Space Usage” on page 104.

Open/Close DB

None

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.