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