15.00 - Teradata Administrator User Guide - Teradata Administrator

Product: Teradata Administrator
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-27

Preface
Audience
Supported Releases
Prerequisites
Changes to This Book
Additional Information
Product Safety Information
Chapter 1 Introduction
Overview
Program Fixes and Change Requests
Online Help
Installation
Chapter 2 Getting Started with Teradata Administrator
Overview
Main Window
Database Tree
Grid Area
Menu Bar
File Menu
Edit Menu
View Menu
Database Menu
Object Menu
Tools Menu
Window Menu
Help Menu
Keyboard Shortcuts
Command Shortcut Keys
Drag and Drop Copying
Print or Save Data
Chapter 3 Configuring Teradata Administrator
Database Access Prerequisites
Step 1 - Define a Data Source
Step 2a - Set Database Options
Step 2b - Set Filtering Options
Step 2c - Set Confirmation Options
Preview Mode
Step 2d - Set Browse Options
Step 2e - Set General Options
Step 2f - Set the Data Directory
Step 3 - Connect to a Data Source
Chapter 4 Working with Databases
Database Tree
Open or Close a Database in the Tree Display
Duplicate Databases
Arrange the Displayed Windows
Refresh the Display
Find a Database, Object or Text String
Copy Database Object Information to the Clipboard
Abort the Current Database Operation
Drop a Database or Database Object
Rename Database Objects
Copy Database Objects From One Database to Another
Delete All Objects in the Database
Browse Window
Displaying the Browse Window
Sorting the Browse Window
Open Another Outline Window to a Data Source
Chapter 5 Performing Maintenance Tasks
Create or Modify User Accounts
User Attributes and Options
Create or Modify Databases
Database Attributes and Options
Create Tables
Table Attributes and Options
Column Attributes and Options
Define Primary Key and Indices Constraints
Define Check Constraints
Define Foreign Key Constraints
Administer Roles
Modify the Comment on an Existing Role
View Access Rights on an Existing Role
Drop an Existing Role
Role Attributes and Options
Administer Authorizations
Create an Authorization
Replace an Authorization
Drop an Authorization
Authorization Attributes and Options
Administer Profiles
Profile Attributes and Options
Administer User-Defined Types
Create a New UDT
Modify the Comment on an Existing UDT
List All Objects that Use and Implement a UDT
Drop an Existing UDT
UDT Attributes and Options
Retrieve UDT Data
Additional Information on UDTs and UDFs
Manage Security Constraints
Create or Administer Security Constraints
Add Security Constraints to Users or Profiles
Add a Security Constraint Column to a Table
Move Space Between Databases
Move Space Options
Chapter 6 Setting Access Rights
Grant or Revoke Object Rights
Grant / Revoke Object Rights Fields
Grant or Revoke System Rights
Grant / Revoke System Rights Fields
Grant or Revoke Column Rights
Grant / Revoke Column Rights Fields
Grant or Revoke Logon Rights
Grant / Revoke Logon Rights Fields
Grant or Revoke Connect Through Rights
Grant / Revoke Connect Through Rights Fields
Chapter 7 Setting Rules for Logging
Work with the Access Log
Access Logging Fields and Controls
Work with the Query Log
Query Logging Fields and Controls
Chapter 8 Displaying Database Information
Display All Objects
List All Objects Report Contents
Display Tables and Indexes
List Tables and Indexes Report Contents
Display Views
List Views Report Contents
Display Macros and Stored Procedures
List Macros and Procedures Report Contents
Display Databases and Users
List Databases and Users Report Contents
Display Database Information
Database Information Report Contents
Display Rights on DB and User
Database Rights On... Report Contents
Display Rights Held by DB and User
Database Rights Held By... Report Contents
Access Rights Codes
Display Role Memberships for the DB and User
Role Memberships Report Contents
Display Table Space Usage
Table Space Report Contents
Display Child Space Usage
Child Space Report Contents
Chapter 9 Displaying Object Information
Display Table Columns
List Columns Report Contents
Display Table Indexes
Indexes Report Contents
Display Table References
Display Table Statistics
Display Table Row Count
Display Table Row Data
Display Table Space Usage
Space Summary Report Contents
Display Table Space Usage by AMP
Space by AMP Report Contents
Display Object Access Rights
Rights Report Contents
Display Users’ Access Rights on an Object
Display the Journal Table
Display the Object Definition
Chapter 10 Working With Queries
Run or Explain a Query
Query Window
Query Window File Menu
Query Window Edit Menu
Query Window Tools Menu
Query Window View Menu
Query Window Help Menu
Query Builder Overview
SQL Statements
Procedure Builder
<User Defined>
Query Builder
Open Query Builder
Query Builder Options
Description of the Options
Create a Custom Syntax File
Insert a Statement or Procedure into the Query Window
Use Query Builder in the Future
Results Window
Results Window File Menu
Results Window Edit Menu
Results Window View Menu
Results Window Help Menu
SQL History Window
SQL History Window File Menu
SQL History Window Edit Menu
SQL History Window View Menu
SQL History Window Help Menu
Glossary

Back to home page