teradata meta data services sql views · mds sql views the teradata mds views are part of mds and...
Post on 12-Jul-2020
14 Views
Preview:
TRANSCRIPT
Teradata Meta Data Services
__________________________________ SQL Views
Release 13.0.2
July 2009
Copyright © 2009 by Teradata Corporation. All Rights Reserved. This document, which includes the information contained herein, is the exclusive property of Teradata Corporation. Any person is hereby authorized to view, copy, print, and distribute this document subject to the following conditions. This document may be used for non-commercial, informational purposes only and is provided on an “AS-IS” basis. Any copy of this document or portion thereof must include this copyright notice and all other restrictive legends appearing in this document. Note that any product, process or technology described in the document may be the subject of other intellectual property rights reserved by Teradata and are not licensed hereunder. No license rights will be implied. Use, duplication or disclosure by the United States government is subject to the restrictions set forth in DFARS 252.227- 7013 (c) (1) (ii) and FAR 52.227-19. Other brand and product names used herein are for identification purposes only and may be trademarks of their respective companies.
Meta Data Services SQL Views 2
Table of Contents
Introduction.....................................................................................................................................................5
MDS SQL Views...........................................................................................................................................................5
meta_BusinessAttrColumns ......................................................................................................................6
meta_BusinessAttributeRules ......................................................................................................................................6
meta_BusinessAttributes..............................................................................................................................................6
meta_BusinessAttrViewCols ........................................................................................................................................7
meta_BusinessEntities .................................................................................................................................................7
meta_BusinessEntityAttrs ............................................................................................................................................7
meta_BusinessEntityTables .........................................................................................................................................8
meta_BusinessEntityViews ..........................................................................................................................................8
meta_BusinessRules....................................................................................................................................................8
meta_BusinessRuleValues ..........................................................................................................................................9
meta_CheckConstraints ...............................................................................................................................................9
meta_ColumnHasTriggers ...........................................................................................................................................9
meta_Columns ...........................................................................................................................................................10
meta_DatabaseBusEntities ........................................................................................................................................11
meta_DatabaseBusinessRules ..................................................................................................................................11
meta_DatabaseOwnsDatabases................................................................................................................................11
meta_Databases ........................................................................................................................................................12
meta_DatabaseSubjectAreas.....................................................................................................................................12
meta_HashIndexes ....................................................................................................................................................12
meta_HashIndexIndices.............................................................................................................................................13
meta_HashIndexTableColumns .................................................................................................................................13
meta_HashIndexTables .............................................................................................................................................14
meta_IndexColumns ..................................................................................................................................................14
meta_Indexes.............................................................................................................................................................15
meta_JoinIndexes ......................................................................................................................................................15
meta_JoinIndexFunctions ..........................................................................................................................................16
meta_JoinIndexIndices...............................................................................................................................................16
meta_JoinIndexTableColumns...................................................................................................................................17
meta_JoinIndexTables ...............................................................................................................................................17
Meta Data Services SQL Views 3
meta_MacroHashIndexes ..........................................................................................................................................17
meta_MacroJoinIndexes ............................................................................................................................................18
meta_MacroParameters.............................................................................................................................................18
meta_MacroReferencesMacros .................................................................................................................................19
meta_Macros..............................................................................................................................................................19
meta_MacroStoredProcedures ..................................................................................................................................20
Meta_MacroTableColumns ........................................................................................................................................20
meta_MacroTables.....................................................................................................................................................20
meta_MacroTriggers ..................................................................................................................................................21
meta_MacroViewColumns .........................................................................................................................................21
meta_MacroViews......................................................................................................................................................21
meta_RefConstraintColumns .....................................................................................................................................22
meta_RefConstraints..................................................................................................................................................22
meta_SPParameters ..................................................................................................................................................22
meta_StoredProcedureMacros ..................................................................................................................................23
meta_StoredProcedures ............................................................................................................................................24
meta_StoredProcedureTables ...................................................................................................................................24
meta_StoredProcedureViews.....................................................................................................................................24
meta_StoredProcHashIndexes ..................................................................................................................................25
meta_StoredProcJoinIndexes ....................................................................................................................................25
meta_StoredProcRefsSPs .........................................................................................................................................25
meta_StoredProcTableColumns ................................................................................................................................26
meta_StoredProcViewColumns..................................................................................................................................26
meta_SubjectAreaEntities ..........................................................................................................................................27
meta_SubjectAreas ....................................................................................................................................................27
meta_SystemMetaloadTypes.....................................................................................................................................27
meta_SystemNodes ...................................................................................................................................................27
meta_TableColumns ..................................................................................................................................................28
meta_TableHasTriggers.............................................................................................................................................29
meta_Tables...............................................................................................................................................................29
meta_TriggerMacros ..................................................................................................................................................29
meta_Triggers ............................................................................................................................................................30
meta_TriggerTables ...................................................................................................................................................30
meta_TV.....................................................................................................................................................................31
meta_TVColumns.......................................................................................................................................................31
Meta Data Services SQL Views 4
meta_TVM..................................................................................................................................................................32
meta_ValidValues ......................................................................................................................................................32
meta_ViewColumnConstants .....................................................................................................................................33
meta_ViewColumnFunctions......................................................................................................................................33
meta_ViewColumns ...................................................................................................................................................34
meta_ViewColumnTableColumns ..............................................................................................................................35
meta_ViewReferencesViews......................................................................................................................................35
meta_Views................................................................................................................................................................35
meta_ViewTableColumns ..........................................................................................................................................36
Meta Data Services SQL Views 5
Introduction This document is a quick reference to the views that provide read access into the Teradata Meta Data Services repository. This document provides information for the following users:
• Teradata MDS end users
• Teradata MDS adminitrators
• Teradata database administrators
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 is a list of the views provide access to the metadata in the Database Information Metamodel (DIM) through the use of standard SQL.
• meta_BusinessAttrColumns • meta_JoinIndexFunctions • meta_StoredProcTableColumns • meta_BusinessAttributeRules • meta_JoinIndexIndices • meta_StoredProcViewColumns • meta_BusinessAttributes • meta_JoinIndexTableColumns • meta_SubjectAreaEntities • meta_BusinessAttrViewCols • meta_JoinIndexTables • meta_SubjectAreas • meta_BusinessEntities • meta_MacroHashIndexes • meta_SystemMetaloadTypes • meta_BusinessEntityAttrs • meta_MacroJoinIndexes • meta_SystemNodes • meta_BusinessEntityTables • meta_MacroParameters • meta_TableColumns • meta_BusinessEntityViews • meta_MacroReferencesMacros • meta_TableHasTriggers • meta_BusinessRules • meta_Macros • meta_Tables • meta_BusinessRuleValues • meta_MacroStoredProcedures • meta_TriggerMacros • meta_CheckConstraints • meta_MacroTableColumns • meta_Triggers • meta_ColumnHasTriggers • meta_MacroTables • meta_TriggerTables • meta_Columns • meta_MacroTriggers • meta_TV • meta_DatabaseBusEntities • meta_MacroViewColumns • meta_TVColumns • meta_DatabaseBusinessRules • meta_MacroViews • meta_TVM • meta_DatabaseOwnsDatabases • meta_RefConstraintColumns • meta_ValidValues • meta_Databases • meta_RefConstraints • meta_ViewColumnConstants • meta_DatabasesSubjectAreas • meta_SPParameters • meta_ViewColumnFunctions • meta_HashIndexes • meta_StoredProcedureMacros • meta_ViewColumns • meta_HashIndexIndices • meta_StoredProcedures • meta_ViewColumnTableColumns • meta_HashIndexTableColumns • meta_StoredProcedureTables • meta_ViewReferencesViews • meta_HashIndexTables • meta_StoredProcedureViews • meta_Views • meta_IndexColumns • meta_StoredProcHashIndexes • meta_ViewTableColumns • meta_Indexes • meta_StoredProcJoinIndexes • meta_JoinIndexes • meta_StoredProcRefsSPs
Meta Data Services SQL Views 6
meta_BusinessAttrColumns Returns the current table columns in the repository systems that have defined Business Attributes. Corresponds to the relationship BusAttrColumn.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
AttributeName VARCHAR(128)
ColumnLoid INTEGER
AttributeLoid INTEGER
meta_BusinessAttributeRules Returns the Business Rules associated with each Business Attribute in the repository. Corresponds to the relationship BusAttrRules.
Column Data Type
AttributeName VARCHAR(128)
RuleName VARCHAR(128)
RuleID INTEGER
RuleDefinition VARCHAR(12500)
AttributeLoid INTEGER
RuleLoid INTEGER
meta_BusinessAttributes Returns the current Business Attributes defined in the repository.
Column Data Type Values
AttributeName VARCHAR(128)
AttributeID INTEGER
AttributeType VARCHAR(6) • AT_DR = Derived Column • AT_NK = Nonkey • AT_PK = Key
Rolename VARCHAR(12500)
ColumnPosition INTEGER
BusinessDefinition VARCHAR(12500)
BusinessNotes VARCHAR(12500)
Meta Data Services SQL Views 7
AttributeLoid INTEGER
meta_BusinessAttrViewCols Returns the current view columns in the repository systems that have defined Business Attributes. Corresponds to the relationship BusAttrViewColumn.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ViewColumnName VARCHAR(128)
AttributeName VARCHAR(128)
ViewColumnLoid INTEGER
AttributeLoid INTEGER
meta_BusinessEntities Returns the current Business Entities defined in the repository.
Column Data Type Values
EntityName VARCHAR(128)
EntityType VARCHAR(6) • ET_DE = Dependent • ET_DR = Derived • ET_IE = Independent
EntityID INTEGER
SourceFile VARCHAR(255)
BusinessDefinition VARCHAR(12500)
BusinessNotes VARCHAR(12500)
EntityLoid INTEGER
meta_BusinessEntityAttrs Returns the Business Attributes comprising each Business Entity in the repository. Corresponds to the relationship BusEntityHasAttributes.
Column Data Type
EntityName VARCHAR(128)
AttributeName VARCHAR(128)
AttributeID INTEGER
AttributeType VARCHAR(6)
AttributeRolename VARCHAR(255)
AttributeColumnPosition INTEGER
Meta Data Services SQL Views 8
AttributeBusinessDefinition VARCHAR(12500)
AttributeBusinessNotes VARCHAR(12500)
EntityLoid INTEGER
AttributeLoid INTEGER
meta_BusinessEntityTables Returns the current tables in the repository systems that have defined Business Entities. Corresponds to the relationship BusEntityTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
EntityName VARCHAR(128)
TableLoid INTEGER
EntityLoid INTEGER
meta_BusinessEntityViews Returns the current views in the repository systems that have defined Business Entities. Corresponds to the relationship BusEntityViews.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
EntityName VARCHAR(128)
ViewLoid INTEGER
EntityLoid INTEGER
meta_BusinessRules Returns the Business Rules defined in the repository.
Column Data Type
RuleName VARCHAR(128)
RuleID INTEGER
RuleDefinition VARCHAR(12500)
MinimumValue VARCHAR(255)
MaximumValue VARCHAR(255)
RuleLoid INTEGER
Meta Data Services SQL Views 9
meta_BusinessRuleValues Returns the Valid Values defined for each Business Rule in the repository. Corresponds to the relationship BusRuleValues.
Column Data Type
RuleName VARCHAR(128)
ValueName VARCHAR(128)
ValueSequenceNumber INTEGER
ValueDefinition VARCHAR(12500)
RuleLoid INTEGER
ValueLoid INTEGER
meta_CheckConstraints Returns the current CHECK constraints for the tables in the repository systems. Corresponds to the relationship TableHasCheckConstraints.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
CheckName VARCHAR(128)
CheckLoid INTEGER
CheckType CHAR(1)
CheckTypeA VARCHAR(18) • Constraint Check • Partitioning Check
CheckBool VARCHAR(8192)
meta_ColumnHasTriggers Returns the table column names comprising the triggers in the repository systems. Corresponds to the relationship ColumnHasTriggers.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
TriggerDatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
ColumnLoid INTEGER
TriggerLoid INTEGER
Meta Data Services SQL Views 10
meta_Columns Returns the columns for the tables, views, macros, and stored procedures defined in the repository systems. The TVType fields returns 'T' for a table, 'V ' for a view, 'M' for a macro, and 'P' for a stored procedure.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TVType VARCHAR(2) T = Table V = View M = Macro P = Stored Procedure
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ColumnID SMALLINT
ColumnLoid INTEGER
ColumnType CHAR(2)
ColumnTypeA VARCHAR(29) ANSI Time Binary Fixed BLOB Binary String VARBYTE Character Fixed CLOB VARCHAR Decimal Date Day Day To Hour Day To Minute Day to Second Date Tag Real/Float Hour Hour To Minute Hour To Second Integer Byte Integer Short Integer BIGINT Minute Month Minute To Second PERIOD(DATE) PERIOD(TIME) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP
) PERIOD(TIMESTAMP)w/TimeZone Second Timestamp w/ TimeZone Timestamp ANSI Timestamp w/ TimeZone User Defined Type Unicode Fixed Character Unicode VARCHAR Year Year To Month
ColumnLength INTEGER
CharType SMALLINT
CharacterSet VARCHAR(8) • Graphic • Kanji1 • Latin • ShiftJIS • Unicode • Other
DecimalTotalDigits SMALLINT
DecimalFractionalDigits SMALLINT
UppercaseFlag VARCHAR(3)
Nullable VARCHAR(3)
DefaultValue VARCHAR(1024)
Meta Data Services SQL Views 11
Compressible VARCHAR(3)
CompressValue VARCHAR(8192)
IDColType VARCHAR(164)
SPParameterType VARCHAR(1)
ColumnTitle VARCHAR(256)
CommentString VARCHAR(255)
ColumnUDTName VARCHAR(128)
meta_DatabaseBusEntities Returns the Business Entities defined for the current databases in the repository systems. Corresponds to the relationship DatabaseHasEntities.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
EntityName VARCHAR(128)
EntityType VARCHAR(6) • ET_DE = Dependent • ET_DR = Derived • ET_IE = Independent
DatabaseLoid INTEGER
EntityLoid INTEGER
meta_DatabaseBusinessRules Returns the Business Rules defined for the current databases in the repository systems. Corresponds to the relationship DatabaseHasRules.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
RuleName VARCHAR(128)
RuleId INTEGER
RuleDefinition VARCHAR(12500)
DBLoid INTEGER
RuleLoid INTEGER
meta_DatabaseOwnsDatabases Returns the names of the databases owned by another database or user. Corresponds to the relationship DatabaseOwnsDatabases.
Column Data Type
SystemName VARCHAR(256)
Meta Data Services SQL Views 12
DatabaseName VARCHAR(128)
OwnedDatabaseName VARCHAR(128)
OwnerLoid INTEGER
OwnedLoid INTEGER
meta_Databases Returns the current databases by systems in the repository. Corresponds to the relationship SystemHasDatabases.
Column Data Type Value
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
DBType VARCHAR(8) USER = Teradata User DATABASE = Teradata Database A = MS Access Database B = DB2 Database I = Informix Database M = SQLServer Database O = Oracle Database R = Redbrick Database S = Sybase Database T = Teradata Database from MIMB load
DBCreatorName VARCHAR(128)
IsSynchronized VARCHAR(45)
DBLoid INTEGER
meta_DatabaseSubjectAreas Returns the Subject Areas defined for the current databases in the repository systems. Corresponds to the relationship DatabaseHasSubjectAreas.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
SubjectAreaName VARCHAR(128)
DatabaseLoid INTEGER
SubjectAreaLoid INTEGER
meta_HashIndexes Returns the current Hash indexes by system and database in the repository. Corresponds to the SystemHasHashIndexes relationship.
Column Data Type
SystemName VARCHAR(256)
Meta Data Services SQL Views 13
DatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
RequestText VARCHAR(12500)
CreatorName VARCHAR(128)
HashIndexLoid INTEGER
meta_HashIndexIndices Returns the sub-indexes of the current Hash indexes by system and database in the repository. Corresponds to the HashIndexHasIndices relationship.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
IndexName VARCHAR(128)
IndexType CHAR(1)
IndexTypeA VARCHAR(35) • Primary • Partition Primary • Secondary • Join • Hash • Primary Key • Unique Constraint • Value ordered secondary • Hash ordered ALL secondary • Value ordered ALL secondary • Ordering column • Multi-column statistics • Derived column partition statistics • Field1 of hash • Field2 of hash
IsUnique VARCHAR(3)
IndexNumber SMALLINT
HashIndexLoid INTEGER
IndexLoid INTEGER
meta_HashIndexTableColumns Returns the table columns referenced by the current hash indexes in the repository systems. Corresponds to the relationship HashIndexReferencesTableColumns.
Column Data Type
Meta Data Services SQL Views 14
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
HashIndexLoid INTEGER
ColumnLoid INTEGER
meta_HashIndexTables "Returns the tables referenced by the current hash indexes in the repository systems. Corresponds to the relationship HashIndexReferencesTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
HashIndexLoid INTEGER
TableLoid INTEGER
meta_IndexColumns Returns the table columns comprising the indexes defined for the repository systems. Corresponds to the relationship IndexHasColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ColunmLoid INTEGER
ColumnPosition SMALLINT
IndexNumber SMALLINT
Meta Data Services SQL Views 15
meta_Indexes Returns the indices (primary, secondary, hash, join, etc.) defined for the current tables in the repository. Corresponds to the relationships TableHasIndexes, DatabaseHasHashIndexes, and DatabaseHasJoinIndexes.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
IndexName VARCHAR(128)
IndexLoid INTEGER
IndexType CHAR(1)
IndexTypeA VARCHAR(35) • Primary • Partition Primary • Secondary • Join • Hash • Primary Key • Unique Constraint • Value ordered secondary • Hash ordered ALL secondary • Value ordered ALL secondary • Ordering column • Multi-column statistics • Derived column partition statistics • Field1 of hash/join • Field2 of hash/join
IsUnique VARCHAR(3)
IndexNumber SMALLINT
meta_JoinIndexes Returns the current join indexes by system and database in the repository. Corresponds to the SystemHasJoinIndexes relationship.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
RequestText VARCHAR(12500)
CreatorName VARCHAR(128)
JoinIndexLoid INTEGER
Meta Data Services SQL Views 16
meta_JoinIndexFunctions Returns the Functions referenced by the current join indexes in the repository systems. Corresponds to the relationship JoinIndexReferencesFunctions.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
FunctionName VARCHAR(128)
JoinIndexLoid INTEGER
FunctionLoid INTEGER
meta_JoinIndexIndices Returns the sub-indexes of the current Join indexes by system and database in the repository. Corresponds to the JoinIndexHasIndices relationship.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
IndexName VARCHAR(128)
IndexType CHAR(1)
IndexTypeA VARCHAR(35) • Primary • Partition Primary • Secondary • Join • Hash • Primary Key • Unique Constraint • Value ordered secondary • Hash ordered ALL secondary • Value ordered ALL secondary • Ordering column • Multi-column statistics • Derived column partition statistics • Field1 of join • Field2 of join
IsUnique VARCHAR(3)
IndexNumber SMALLINT
JoinIndexLoid INTEGER
IndexLoid INTEGER
Meta Data Services SQL Views 17
meta_JoinIndexTableColumns Returns the table columns referenced by the current join indexes in the repository systems. Corresponds to the relationship JoinIndexReferencesTableColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
JoinIndexLoid INTEGER
ColumnLoid INTEGER
meta_JoinIndexTables Returns the tables referenced by the current join indexes in the repository systems. Corresponds to the relationship JoinIndexReferencesTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
JoinIndexLoid INTEGER
TableLoid INTEGER
meta_MacroHashIndexes Returns the hash indexes referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesHashIndexes.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
HashIndexDatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
MacroLoid INTEGER
Meta Data Services SQL Views 18
HashIndexLoid INTEGER
meta_MacroJoinIndexes Returns the join indexes referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesJoinIndexes.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
JoinIndexDatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
MacroLoid INTEGER
JoinIndexLoid INTEGER
meta_MacroParameters Returns the parameters defined for the current macros in the repository systems. Corresponds to the relationship MacroHasParameters.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
ParameterName VARCHAR(128)
ParameterPositionID SMALLINT
ParameterDataType CHAR(2)
ParameterDataTypeA VARCHAR(29) ANSI Time Binary Fixed BLOB Binary String VARBYTE Character Fixed CLOB VARCHAR Decimal Date Day Day To Hour Day To Minute Day to Second Date Tag Real/Float Hour Hour To Minute Hour To Second Integer Byte Integer Short Integer BIGINT Minute Month Minute To Second PERIOD(DATE) PERIOD(TIME) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP) PERIOD(TIMESTAMP)w/TimeZone Second Timestamp w/TimeZone Timestamp ANSI Timestamp w/TimeZone Unicode Fixed Character User Defined Type Year
Meta Data Services SQL Views 19
Year To Month ParameterLength INTEGER
CharType SMALLINT
CharacterSet VARCHAR(8) • Graphic • Kanji1 • Latin • ShiftJIS • Unicode • Other
DefaultValue VARCHAR(1024)
ParameterTitle VARCHAR(256)
ParameterComment VARCHAR(255)
MacroLoid INTEGER
ParameterLoid INTEGER
meta_MacroReferencesMacros Returns the macros referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesMacros.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
RefdDatabaseName VARCHAR(128)
RefdMacroName VARCHAR(128)
MacroLoid INTEGER
RefdMacroLoid INTEGER
meta_Macros Returns the current macros by database in the systems in the repository. Corresponds to the relationship DatabaseHasMacros.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
CreatorName VARCHAR(128)
MacroLoid INTEGER
Meta Data Services SQL Views 20
meta_MacroStoredProcedures Returns the Stored Procedures referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesSPs.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
SPDatabaseName VARCHAR(128)
SPName VARCHAR(128)
MacroLoid INTEGER
SPLoid INTEGER
Meta_MacroTableColumns Returns the table columns referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesTableColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
MacroLoid INTEGER
ColumnLoid INTEGER
meta_MacroTables Returns the tables referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
MacroLoid INTEGER
Meta Data Services SQL Views 21
TableLoid INTEGER
meta_MacroTriggers Returns the triggers referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesTriggers.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
TriggerDatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
MacroLoid INTEGER
TriggerLoid INTEGER
meta_MacroViewColumns Returns the view columns referenced by the current macros in the repository systems. Corresponds to the relationship MacroReferencesViewColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
ViewDatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ColumnName VARCHAR(128)
MacroLoid INTEGER
ColumnLoid INTEGER
meta_MacroViews Returns the Views referenced by the current Macros in the repository systems. Corresponds to the MacroReferencesViews relationship.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
MacroName VARCHAR(128)
ViewDatabaseName VARCHAR(128)
ViewName VARCHAR(128)
Meta Data Services SQL Views 22
MacroLoid INTEGER
ViewLoid INTEGER
meta_RefConstraintColumns Returns the table columns comprising the current REFERENCE constraints in the repository systems. Corresponds to the relationship ConstraintReferencesColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ReferenceId SMALLINT
ReferenceName VARCHAR(128)
ForeignKeyColumnName VARCHAR(128)
ReferencedDatabaseName VARCHAR(128)
ReferencedTableName VARCHAR(128)
ReferencedColumnName VARCHAR(128)
meta_RefConstraints Returns the current REFERENCE constraints for the tables in the repository systems. Corresponds to the relationship TableHasRefConstraints.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ReferenceName VARCHAR(128)
ReferenceLoid INTEGER
ReferenceID SMALLINT
ReferencedDatabase VARCHAR(128)
ReferencedTable VARCHAR(128)
meta_SPParameters Returns the parameters defined for the current stored procedures in the repository systems. Corresponds to the relationship SPHasParameters.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
Meta Data Services SQL Views 23
StoredProcedureName VARCHAR(128)
ParameterName VARCHAR(128)
ParameterPositionID SMALLINT
ParameterType VARCHAR(12) • Input • Output • Input/Output
ParameterDataType CHAR(2)
ParameterDataTypeA VARCHAR(29) ANSI Time Binary Fixed BLOB Binary String VARBYTE Character Fixed CLOB VARCHAR Decimal Date Day Day To Hour Day To Minute Day to Second Date Tag Real/Float Hour Hour To Minute Hour To Second Integer Byte Integer Short Integer BIGINT Minute Month Minute To Second PERIOD(DATE) PERIOD(TIME) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP) PERIOD(TIMESTAMP)w/TimeZone Second Timestamp w/TimeZone Timestamp ANSI Timestamp w/TimeZone Unicode Fixed Character User Defined Type Year Year To Month
ParameterLength INTEGER
CharType SMALLINT
CharacterSet VARCHAR(8) • Graphic • Kanji1 • Latin • ShiftJIS • Unicode • Other
ParameterComment VARCHAR(255)
SPLoid INTEGER
ParameterLoid INTEGER
meta_StoredProcedureMacros Returns the macros referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesMacros.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
MacroDatabaseName VARCHAR(128)
MacroName VARCHAR(128)
Meta Data Services SQL Views 24
SPLoid INTEGER
MacroLoid INTEGER
meta_StoredProcedures Returns the current stored procedures in the databases of the repository systems. Corresponds to the relationship DatabaseHasStoredProcedures.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
SPLastAlterTS TIMESTAMP
IsSynchronized VARCHAR(6)
SPComment VARCHAR(255)
SPText VARCHAR(12500)
CreatorName VARCHAR(128)
SPLoid INTEGER
meta_StoredProcedureTables Returns the tables referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
SPLoid INTEGER
TableLoid INTEGER
meta_StoredProcedureViews Returns the views referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesViews.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
Meta Data Services SQL Views 25
ViewDatabaseName VARCHAR(128)
ViewName VARCHAR(128)
SPLoid INTEGER
ViewLoid INTEGER
meta_StoredProcHashIndexes Returns the hash indexes referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesHashIndexes.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
HashIndexDatabaseName VARCHAR(128)
HashIndexName VARCHAR(128)
StoredProcedureLoid INTEGER
HashIndexLoid INTEGER
meta_StoredProcJoinIndexes Returns the join indexes referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesJoinIndexes.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
JoinIndexDatabaseName VARCHAR(128)
JoinIndexName VARCHAR(128)
StoredProcedureLoid INTEGER
JoinIndexLoid INTEGER
meta_StoredProcRefsSPs Returns the stored procedures referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesStoredProcedures.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
Meta Data Services SQL Views 26
RefdStoredProcedureDatabase VARCHAR(128)
RefdStoredProcedureName VARCHAR(128)
SPLoid INTEGER
RefdSPLoid INTEGER
meta_StoredProcTableColumns Returns the table columns referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesTableColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
StoredProcedureLoid INTEGER
ColumnLoid INTEGER
meta_StoredProcViewColumns Returns the view columns referenced by the current stored procedures in the repository systems. Corresponds to the relationship SPReferencesViewColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
StoredProcedureName VARCHAR(128)
ViewDatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ColumnName VARCHAR(128)
StoredProcedureLoid INTEGER
ColumnLoid INTEGER
Meta Data Services SQL Views 27
meta_SubjectAreaEntities Returns the Business Entities comprising each Subject Area in the repository. Corresponds to relationship SubjectAreaEntities.
Column Data Type
SubjectAreaName VARCHAR(128)
EntityName VARCHAR(128)
EntityType VARCHAR(6)
SubjectAreaLoid INTEGER
EnityLoid INTEGER
meta_SubjectAreas Returns the current Subject Areas defined in the repository.
Column Data Type
SubjectAreaName VARCHAR(128)
SubjectAreaID INTEGER
BusinessDefinition VARCHAR(2048)
Author VARCHAR(255)
SubjectAreaLoid INTEGER
meta_SystemMetaloadTypes Returns the MetaloadTypes entries for the current systems in the repository. Corresponds to SystemHasMetaloadTypes.
Column Data Type
SystemName VARCHAR(256)
TypeName VARCHAR(128)
SystemLoid INTEGER
TypeLoid INTEGER
meta_SystemNodes Returns the name of the nodes comprising the systems in the repository. Corresponds to the relationship SystemHasNodes.
Column Data Type
SystemName VARCHAR(256)
NodeName VARCHAR(256)
SystemLoid INTEGER
NodeLoid INTEGER
Meta Data Services SQL Views 28
meta_TableColumns Returns the columns for the current tables of the systems in the repository. Corresponds to the relationship TableHasColumns.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ColumnId SMALLINT
ColumnLoid INTEGER
ColumnType CHAR(2)
ColumnTypeA VARCHAR(29) ANSI Time Binary Fixed BLOB Binary String VARBYTE Character Fixed CLOB VARCHAR Decimal Date Day Day To Hour Day To Minute Day to Second Date Tag Real/Float Hour Hour To Minute Hour To Second Integer Byte Integer Short Integer BIGINT Minute Month Minute To Second PERIOD(DATE) PERIOD(TIME) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP
) PERIOD(TIMESTAMP)w/TimeZone Second Timestamp w/ TimeZone Timestamp ANSI Timestamp w/ TimeZone User Defined Type Unicode Fixed Character Unicode VARCHAR Year Year To Month
ColumnLength INTEGER
CharType SMALLINT
CharacterSet VARCHAR(8) • Graphic • Kanji1 • Latin • ShiftJIS • Unicode • Other
DecimalTotalDigits SMALLINT
DecimalFractDigits SMALLINT
UppercaseFlag VARCHAR(3)
Nullable VARCHAR(3)
DefaultValue VARCHAR(1024)
Compressible VARCHAR(3)
CompressValue VARCHAR(8192)
Meta Data Services SQL Views 29
IDColType VARCHAR(164)
ColumnTitle VARCHAR(256)
CommentString VARCHAR(255)
meta_TableHasTriggers Returns the tables in the repository systems for which triggers are defined. Corresponds to the relationship TableHasTriggers.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
TriggerDatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
TableLoid INTEGER
TriggerLoid INTEGER
meta_Tables Returns the current tables by system and database in the repository. Corresponds to the DatabaseHasTables relationship.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TableName VARCHAR(128)
TableLoid INTEGER
TableVersion SMALLINT
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
CreatorName VARCHAR(128)
meta_TriggerMacros Returns the macros referenced by the current triggers in the repository systems. Corresponds to the relationship TriggerReferencesMacros.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
Meta Data Services SQL Views 30
MacroDatabaseName VARCHAR(128)
MacroName VARCHAR(128)
TriggerLoid INTEGER
MacroLoid INTEGER
meta_Triggers Returns the current triggers defined for the repository systems. Corresponds to the relationship DatabaseHasTriggers.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
IsSynchronized VARCHAR(6)
TriggerComment VARCHAR(255)
TriggerEnabled VARCHAR(3)
TriggerKind VARCHAR(14) • Each Row • Each Statement
TriggerEvent VARCHAR(6) • Delete • Insert • Update
TriggerActionTime VARCHAR(12) • Before Event • After Event
TriggerOrder SMALLINT
TriggerCreateTime TIMESTAMP
TriggerLastEnableDisableTS TIMESTAMP
CreatorName VARCHAR(128)
TriggerText VARCHAR(12500)
TriggerLoid INTEGER
meta_TriggerTables Returns the tables referenced by the current triggers in the repository systems. Corresponds to the relationship TriggerReferencesTables.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TriggerName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
Meta Data Services SQL Views 31
TriggerLoid INTEGER
TableLoid INTEGER
meta_TV Returns the tables and views defined in the repository systems. The TVType field returns 'T' for a table and 'V' for a view.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TVType VARCHAR(2)
TableName VARCHAR(128)
TableLoid INTEGER
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
CreatorName VARCHAR(128)
meta_TVColumns Returns the columns for the tables and views defined in the repository systems. The TVType fields returns 'T' for a table and 'V ' for a view.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TVType VARCHAR(2)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ColumnID SMALLINT
ColumnLoid INTEGER
ColumnType CHAR(2)
ColumnLength INTEGER
CharType SMALLINT
DecimalTotalDigits SMALLINT
DecimalFractionalDigits SMALLINT
UppercaseFlag VARCHAR(3)
Nullable VARCHAR(3)
DefaultValue VARCHAR(1024)
Meta Data Services SQL Views 32
Compressible VARCHAR(3)
CompressValue VARCHAR(8192)
IDColType VARCHAR(164)
SPParameterType VARCHAR(1)
ColumnTitle VARCHAR(256)
CommentString VARCHAR(255)
ColumnUDTName VARCHAR(128)
meta_TVM Returns the tables, views, triggers, macros, procedures, hash indexes, and join indexes defined in the repository systems. The TVType field returns 'T' (table), 'V' (view), 'G' (trigger), 'P' (procedure), 'HI' (hash index), and 'JI' (join index).
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
TVType VARCHAR(2)
TVName VARCHAR(128)
TVLoid INTEGER
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
CreatorName VARCHAR(128)
meta_ValidValues Returns the current ValidValue definitions in the repository.
Column Data Type
ValueName VARCHAR(128)
ValueDefinition VARCHAR(12500)
DisplayValue VARCHAR(255)
ValueSequenceNumber INTEGER
ValueLoid INTEGER
Meta Data Services SQL Views 33
meta_ViewColumnConstants Returns the Constants referenced by the current view columns in the repository systems. Corresponds to the relationship ViewColumnReferencesConstants.
Column Data Type Value
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ViewColumnName VARCHAR(128)
ConstantType VARCHAR(128) • ACCOUNT • ACTIVITY_COUNT • ALL • ANSIDATE • ASCII • BIGINT • BINARY • CHAR_SET_GRAPHIC • CHARSET_COLL • CURRDATE • CURRTIME • CURRTIMESTAMP • DATABASE • DATE • DECIMAL • DEFAULT • DQUOTESTR • EBCDIC • FLOAT • HEXSTR • HIGH • HOST • INTEGER • INTEGERDATE • JIS_COLL • KANJI • KANJISJIS • LATIN1 • LOCAL • LOW • MEDIUM • MULTINATIONAL • NAME • NULL • OFF • PARMNAME • PREPARE_COUNT • PROFILE • ROLE • SESSION • SQLCODE • SQLSTATE • SQUOTESTR • TIME • UNICODE • UNKNOWN • USER
ConstantValue VARCHAR(1024)
ColumnLoid INTEGER
ConstantLoid INTEGER
meta_ViewColumnFunctions Returns the Functions referenced by the current view columns in the repository systems. Corresponds to the relationship ViewColumnReferencesFunctions.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ViewColumnName VARCHAR(128)
FunctionName VARCHAR(128)
ColumnLoid INTEGER
FunctionLoid INTEGER
Meta Data Services SQL Views 34
meta_ViewColumns Returns the columns for the current views in the systems in the repository. Corresponds to the relationship ViewHasColumns.
Column Data Type Values
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ColumnName VARCHAR(128)
ColumnID SMALLINT
ColumnLoid INTEGER
ColumnType CHAR(2)
ColumnTypeA VARCHAR(29) ANSI Time Binary Fixed BLOB Binary String VARBYTE Character Fixed CLOB VARCHAR Decimal Date Day Day To Hour Day To Minute Day to Second Date Tag Real/Float Hour Hour To Minute Hour To Second Integer Byte Integer Short Integer BIGINT Minute Month Minute To Second PERIOD(DATE) PERIOD(TIME) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP
) PERIOD(TIMESTAMP)w/TimeZone Second Timestamp w/ TimeZone Timestamp ANSI Timestamp w/ TimeZone User Defined Type Unicode Fixed Character Unicode VARCHAR Year Year To Month
ColumnLength INTEGER
CharType SMALLINT
CharacterSet VARCHAR(8) • Graphic • Kanji1 • Latin • ShiftJIS • Unicode • Other
DecimalTotalDigits SMALLINT
DecimalFractDigits SMALLINT
Nullable VARCHAR(3)
ColumnTitle VARCHAR(256)
CommentString VARCHAR(255)
Meta Data Services SQL Views 35
meta_ViewColumnTableColumns Returns the table columns referenced by the current view columns in the repository systems. Corresponds to the relationship ViewColReferencesTableCols.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
ViewColumnName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ViewColumnLoid INTEGER
ColumnLoid INTEGER
meta_ViewReferencesViews Returns the views referenced by a view. Corresponds to the relationship ViewReferencesViews.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
RefdViewDatabaseName VARCHAR(128)
RefdViewName VARCHAR(128)
ViewLoid INTEGER
RefViewLoid INTEGER
meta_Views Returns the current views by database in the systems in the repository. Corresponds to the relationship DatabaseHasViews.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
VeiwLoid INTEGER
IsSynchronized VARCHAR(6)
LastAlterTimestamp TIMESTAMP
Meta Data Services SQL Views 36
CreatorName VARCHAR(128)
meta_ViewTableColumns Returns the table columns referenced by the current views in the repository systems. Corresponds to the relationship ViewHasTableColumns.
Column Data Type
SystemName VARCHAR(256)
DatabaseName VARCHAR(128)
ViewName VARCHAR(128)
TableDatabaseName VARCHAR(128)
TableName VARCHAR(128)
ColumnName VARCHAR(128)
ColumnLoid INTEGER
ViewLoid INTEGER
top related