17.00 - How to See All Columns of a View - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The output of some views extends beyond an 80-character width display. To see all the columns, you can either:

  • Cast the name columns to shorter lengths
  • Use the SET FOLDLINE and SET SIDETITLES options in BTEQ