The Data Dictionary - Teradata Vantage - Analytics Database

• Location, identification, version
• Database name, table name, creator name, and user names of all owners in hierarchy
• Columns (name, data type, length, and phrases for each)
• User/creator access privileges
• Indexes
• Constraints
• Table backup and protection (including fallback and permanent journaling status)
• Creation timestamp

• Database name, creator name, owner name, and account name
• Space allocation (if any) including the following:
  • Permanent
  • Spool
  • Temporary
• Number of fallback tables
• Collation type
• Creation timestamp
• Timestamp of last alteration and name of user who altered it
• Role and profile names
• Revision numbers for UDF library and any XSP libraries by Application Category

• View or macro text
• Creation time attributes
• User and creator access privileges

• Creation time attributes
• Parameters (name, data type, and default format for each)
• User and creator access privileges

• C/C++ source code and object code
• External stored procedure name
• External name
• Data types of parameters
• Source file language
• Data accessing characteristic
• Parameter passing convention
• Execution protection mode
• Character type
• Platform type

• Java external stored procedure name
• External file reference
• Data types of parameters
• Source file language
• Data accessing characteristic
• Parameter passing convention
• Execution protection mode
• Character type
• Platform type

• Java object code
• JAR name
• External name
• Platform type
• Revision number

• IDs of the following:
  • Table
  • Trigger
  • Database and subject table database
  • User who created trigger
  • User who last updated trigger
• Timestamp of last update
• Indexes
• Trigger name
• Whether trigger is enabled
• Triggering event
• Firing order
• Default character set
• Creation text and time stamp
• Overflow text, that is, trigger text that exceeds a specified limit
• Fallback tables

• C source code and object code
• Function call name
• Specific name
• External name
• Data types of parameters
• Function class
• Source file language
• Data accessing characteristic
• Parameter passing convention
• Deterministic characteristic
• Null-call characteristic
• Execution protection mode
• Character type
• Platform type

• Function call name
• Specific name
• External name
• Data types of parameters
• Function class
• Source file language
• Data accessing characteristic
• Parameter passing convention
• Deterministic characteristic
• Null-call characteristic
• Execution protection mode
• Character type
• Platform type

• C source code and object code
• Function call name
• Specific name
• External name
• Data types of parameters
• Function class
• Source file language
• Data accessing characteristic
• Parameter passing convention
• Deterministic characteristic
• Null-call characteristic
• Execution protection mode
• Character type
• Platform type

DBC.UDTInfo:

• Type name
• Type kind (Distinct or Structured)
• Whether type is instantiable
• Default transform group (name)
• Ordering form (full ordering or equals only - distinct and structured types are always full)
• Ordering category (map or relative - distinct and structured types are always map)
• Ordering routine ID
• Cast count

DBC.UDTCast:

• Whether cast is implicit assignment
• Cast routine ID

DBC.UDTTransform:

• Default transform group name
• ToSQL routine ID
• FromSQL routine ID