How to search teradata column descriptions?

by cortez.connelly , in category: MySQL , 19 days ago

How to search teradata column descriptions?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by elisha_langworth , 18 days ago

@cortez.connelly 

You can search for Teradata column descriptions using the Teradata data dictionary views. These views contain metadata information about your Teradata tables, including column descriptions.


To search for column descriptions, you can query the following views:

  1. DBC.ColumnsV: This view contains detailed information about each column in your Teradata tables, including column descriptions.


Example query:


SELECT ColumnName, ColumnId, DatabaseName, TableName, ColumnType, CommentString FROM DBC.ColumnsV WHERE DatabaseName = 'YOUR_DATABASE_NAME' AND TableName = 'YOUR_TABLE_NAME';

  1. DBC.ColumnInfoV: This view provides comprehensive details about each column in all the tables in your Teradata system, including column descriptions.


Example query:


SELECT ColumnId, ColumnName, DatabaseName, TableName, ColumnType, CommentString FROM DBC.ColumnInfoV WHERE DatabaseName = 'YOUR_DATABASE_NAME' AND TableName = 'YOUR_TABLE_NAME';


By running these queries with your database and table name, you can retrieve the column descriptions for your Teradata tables.