SET CSVHEADING

Purpose

Enable or disable the inclusion of field name headings in COPY TO ... TYPE CSV exports

Syntax

SET CSVHEADING ON | OFF | (<expL>)

See Also

APPEND FROM, COPY, COPY FILE, COPY STRUCTURE, COPY STRUCTURE EXTENDED, DECRYPT, ENCRYPT, SET FILTER, SET XMLFORMAT

Description

The SET CSVHEADING set command works in conjunction with the COPY TO ... TYPE CSV command. If SET CSVHEADING is ON (default), the first line of the csv text file created will be the field names. If SET CSVHEADING is OFF, the field names will be omitted.

Example

open database southwind
use products
set csvheading off
copy to exportproducts type CSV delimited with '|'
type exportproducts.csv