SQL Access to the Data Dictionary - Teradata Vantage - Analytics Database

Every time you log on to Vantage, do 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 Data Dictionary tables in the form of logs, such as the AccLogTbl table or the EventLog table.

The Data Dictionary contains Unicode system views. However, to maintain backward compatibility, Teradata provides compatibility system views to translate object names to the Kanji1/Latin. For more information on Unicode and compatibility system views, see Teradata Vantage™ - Data Dictionary and Teradata Vantage™ - 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, to access information in the Personnel database, you can query the DBC.DatabasesV view as follows:

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

Sample result:

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