All AMPs Online - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

An all-AMPs archive (or dictionary archive) of a database or table contains the Teradata Database dictionary rows that are needed to define the entity.

This table alphabetically lists the dictionary rows or tables that are archived by an all-AMPs data archive (or a dictionary tables archive) of a user database or table.

Dictionary Rows and Tables Archived for User Database 
Tables and Table Rows Description
ConstraintNames Constraints that have names
DBCAssociation Retrieves information about tables that have been ported using the Dump/Restore facility
Dependency Stores relationships among a UDT, its dependent routines, User- Defined Casts, User-Defined Transforms, User-Defined Orderings, and any dependency on any other database object
IdCol Identity column
Indexes Columns that are indexes
IndexNames Indexes that have names
QueryStatsTbl Saves information about collected statistics on the queries
ReferencedTbls Referenced columns (i.e., Parent Key) for Parent tables
ReferencingTbls Referencing columns (i.e., Foreign Key) for Child tables
StatsTbl Saves information about collected statistics on the base tables, views, or queries
TableConstraints Table level Check constraints
TextTbl System table containing overflow DDL text
TriggersTbl Definition of all triggers in the database
TVFields All columns in data tables and views
TVM All objects in the database
UDFInfo Information on user-defined functions
UnresolvedReferences Unresolved referential constraints