How to search teradata column descriptions?

by cortez.connelly , in category: MySQL , 5 months ago

How to search teradata column descriptions?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by elisha_langworth , 5 months 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.

Related Threads:

How to search a numeric column in teradata?
How to copy column names from teradata?
How to update column with row_number() in teradata?
How to update a column with a null value in teradata?
How to get column count from a table in teradata?
How to handle nulls in date column in teradata?