TD_ColumnSummary Function | Teradata Vantage - TD_ColumnSummary - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
TD_ColumnSummary displays the following for each specified input table column:
  • Column name
  • Coumn data type
  • Count of these values:
    • Non-NULL
    • NULL
    • Blank (all space characters) (NULL for numeric data type)
    • Zero (NULL for nonnumeric data type)
    • Positive (NULL for nonnumeric data type)
    • Negative (NULL for nonnumeric data type)
  • Percentage of NULL values
  • Percentage of non-NULL values
  • This function requires the UTF8 client character set for UNICODE data.
  • This function does not support Pass Through Characters (PTCs).

    For information about PTCs, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.

  • This function does not support KanjiSJIS or Graphic data types.