MDS SQL Views - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

MDS SQL Views

The Teradata MDS Views are part of MDS and reside in the space assigned for the MDS repository database on Teradata. These pre-defined views provide users with a way to retrieve frequently used data from underlying MDS repository tables.

The following views provide access to the metadata in the Database Information Metamodel (DIM) through the use of standard SQL.

 
  • meta_BusinessAttrColumns
  • meta_BusinessAttributeRules
  • meta_BusinessAttributes
  • meta_BusinessAttrViewCols
  • meta_BusinessEntities
  • meta_BusinessEntityAttrs
  • meta_BusinessEntityTables
  • meta_BusinessEntityViews
  • meta_BusinessRules
  • meta_BusinessRuleValues
  • meta_CheckConstraints
  • meta_ColumnHasTriggers
  • meta_Columns
  • meta_ColumnSecurityConstraints
  • meta_ColumnUDTs
  • meta_DatabaseBusEntities
  • meta_DatabaseBusinessRules
  • meta_DatabaseOwnsDatabases
  • meta_Databases
  • meta_DatabaseSubjectAreas
  • meta_DerivedPeriodColumns
  • meta_ErrorTables
  • meta_FunctionParameters
  • meta_HashIndexIndices
  • meta_HashIndexTableColumns
  • meta_HashIndexTables
  • meta_IndexColumns
  • meta_Indexes
  • meta_IndexPartitioning
  • meta_JoinIndexes
  • meta_JoinIndexFunctions
  • meta_JoinIndexIndices
  • meta_JoinIndexPartitioning
  • meta_JoinIndexTableColumns
  • meta_JoinIndexTables
  • meta_MacroFunctions
  • meta_MacroHashIndexes
  • meta_MacroJoinIndexes
  • meta_MacroParameters
  • meta_MacroParameterUDTs
  • meta_MacroReferencesMacros
  • meta_Macros
  • meta_MacroStoredProcedures
  • meta_MacroTableColumns
  • meta_MacroTables
  • meta_MacroTriggers
  • meta_MacroViewColumns
  • meta_MacroViews
  • meta_PartitionColumns
  • meta_Partitioning
  • meta_RefConstraintColumns
  • meta_RefConstraints
  • meta_SecurityConstraintFuncs
  • meta_SecurityConstraints
  • meta_SecurityConstraintValues
  • meta_SPParameters
  • meta_SPParameterUDTs
  • meta_StoredProcedureMacros
  • meta_StoredProcedures
  • meta_StoredProcedureTables
  • meta_StoredProcedureViews
  • meta_StoredProcHashIndexes
  • meta_StoredProcJoinIndexes
  • meta_StoredProcRefsSPs
  • meta_StoredProcTableColumns
  • meta_StoredProcViewColumns
  • meta_SubjectAreaEntities
  • meta_SubjectAreas
  • meta_SystemMetaloadTypes
  • meta_SystemNodes
  • meta_TableColumns
  • meta_TableHasTriggers
  • meta_TablePartitioning
  • meta_Tables
  • meta_TriggerFunctions
  • meta_TriggerMacros
  • meta_Triggers
  • meta_TriggerTables
  • meta_TriggerUDTs
  • meta_TV
  • meta_TVColumns
  • meta_TVM
  • meta_UDFFunctions
  • meta_UDFs
  • meta_UDTAttributes
  • meta_UDTAttributeUDTs
  • meta_UDTFunctions
  • meta_UDTs
  • meta_UserSecConstraintValues
  • meta_UserSecurityConstraints
  • meta_ValidValues
  • meta_ViewColSecurityConstraints
  • meta_ViewColumnConstants
  • meta_ViewColumnFunctions
  • meta_ViewColumns
  • meta_ViewColumnTableColumns
  • meta_ViewColumnUDTs
  • meta_ViewFunctions
  • meta_ViewReferencesViews
  • meta_Views
  • meta_ViewTableColumns
  • meta_ViewTables