17.10 - CSV File Headers and Schemas - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

If the file has no header record, specify HEADER ('FALSE').

Whether or not the table has a header record:
  • You can specify a nondefault field delimiter or character set only with ROWFORMAT.
  • If you do not specify ROWFORMAT, NOS generates the ROWFORMAT clause.

    The generated clause specifies the values of field_delimiter and character_set (fd_value and cs_value), based on the file encoding.