how can I bcp out a table into a text file including the header row in the text file

Shell Programming and Scripting
1

Hi All,

I need to BCP out a table into a text file along with the table headers. Normal BCP out command only bulk copies the data, and not the headers.

I am using the following command:

bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword  -efile.dat.err

Regards,
Shilpa.