Database Menu - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Database Menu

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 97.

List Tables & Indexes

Display each table and index in the selected database.

“Display Tables and Indexes” on page 98.

List Views

Display each view in the selected database.

“Display Views” on page 99.

List Macros & Procedures

Display each macro, stored procedure in the selected database.

“Display Macros and Stored Procedures” on page 100.

List Databases & Users

Display all databases and users created under the selected database.

“Display Databases and Users” on page 100.

Database Information

None

Display information on the selected database.

“Display Database Information” on page 101.

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 103.

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 103.

Role Memberships

None

Display role memberships assigned to the selected user.

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

Table Space

Display space usage for each table in the selected database.

“Display Table Space Usage” on page 107.

Child Space

None

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

“Display Child Space Usage” on page 108.

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.