Syntax
[##] copy tablename
([columnname = format [with null [(value)]]
{, columnname = format [with null[(value)]]}])
into | from "filename[, type]"
[with with-clause]
The with-clause consists of a comma-separated list of one or more of the following items:
on_error = terminate | continue
error_count = n
rollback = enabled | disabled
log = "filename"
row_estimate = n
The following options are valid only for bulk copy operations. For details about these settings, see
Modify Statement—Change Table or Index Properties. The value specified for any of these options becomes the new setting for the table, and override any settings you have made previously (either using the modify statement or during a previous copy operation).
allocation = n
extend = n
fillfactor = n (isam, hash, and btree only)
minpages = n (hash only)
maxpages = n (hash only)
leaffill = n (btree only)
nonleaffill = n (btree only)