You can use a terminator to mark the end of a column or row, separating one from the next. The default is no terminator.
Field terminators separate table columns.
A row terminator is a field terminator for the last field in the row of the table or file.
Terminators are very useful for dealing with character data because you can choose human-readable terminators. The bcp character option, which uses tabs between each column with a newline terminator at the end of each row, is an example of using terminators that enhance the readability of a data file.
When you prepare data for use with other programs, and when you want to use bcp to prepare tabular data, supply your own terminators. The available terminators are:
Tabs,
indicated by \t
New
lines, indicated by \n
Carriage
returns, indicated by \r
Backslash,
indicated by \
Null terminators (no visible terminator), indicated
by \0
Any printable character, for example, *, A, t, |
Strings of up to 10 printable characters, including some or all of the terminators listed above (for example, **\t**, end, !!!!!!!!!!, and \t--\n)
Control
characters (ASCII 0–25)
cannot be printed.
