15.00 - 15.10 - SQL Access to the Data Dictionary - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Every time you log on to Teradata Database, perform an SQL query, or type a password, you are using the Data Dictionary.

For security and data integrity reasons, the only SQL DML command you can use on the Data Dictionary is the SELECT statement. You cannot use the INSERT, UPDATE, MERGE, or DELETE SQL statements to alter the Data Dictionary, except for some Data Dictionary tables, such as the AccLogTbl table or the EventLog table.

The Data Dictionary contains Unicode system views. However, to maintain backwards compatibility, Teradata provides compatibility system views to translate object names to the Kanji1/Latin. For more information on Unicode and compatibility system views, see Data Dictionary and Database Administration.

You can use SELECT to examine any view in the Data Dictionary to which your database administrator has granted you access. For example, if you need to access information in the Personnel database, then you can query the DBC.DatabasesV view as shown:

  
SELECT Databasename,
         Creatorname,
         Ownername,
         Permspace
  FROM DBC.DatabasesV
  WHERE Databasename=’Personnel’
  ;

The query above produces a report like this:

Databasename			Creatorname					Ownername				Permspace
Personnel		Jones		Jones	1,000,000

For more information on the topics presented in this chapter, see the following Teradata Database book.

 

IF you want to learn more about…

See…

Data Dictionary

Data Dictionary

 

 

 

Data Dictionary Views

SQL Access to the Data Dictionary