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

meta_Databases

Returns the current databases by systems in the repository. Corresponds to the relationship SystemHasDatabases.

 

Table 87: Columns, Data Types, and Values of the meta_Databases View  

Column

Data Type

Values

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