For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
| Name | The name of the field to be written. |
| Type |
This format supports the following field types.  bigint
This type is used to represent 64-bit signed integers. binary
This type is used to represent fixed-length binary data up to a length of 8000 bytes. bit
This type is used to represent an integer with a value of 1 or 0. char
This type is used to represent fixed-length character data up to a length of 8000 bytes. The number of characters that can be stored depends on the code page of the server. date
This type is used to represent date data from January 1, 0001 to December 31, 9999. datetime
This type is used to represent date and time data from January 1, 1753 to December 31, 9999 with an accuracy of 3.33 milliseconds. datetime2
This type is used to represent date and time data from January 1, 0001 to December 31, 9999, with an accuracy of 100 nanoseconds. datetimeoffset
This type is used to represent date and time data in a specific timezone from January 1, 0001 to December 31, 9999, with an accuracy of up to 100 nanoseconds. float
This type is used to represent 64-bit floating precision numbers. geography
This type is used to represent ellipsoidal (round-earth) spatial data. geometry
This type is used to represent planar, or Euclidean (flat-earth), spatial data. image
This type is used to represent variable length binary data up to a length of 2^31-1 bytes. Use varbinary_max instead. integer
This type is used to represent 32-bit signed integers. money
This type is used to represent monetary data values from -922,337,203,685,477.5808 to 922,337,203,685,477.5807. nchar
This type is used to represent fixed-length character data up to a length of 4000 Unicode UCS-2 characters. numeric
This type is used to represent fixed precision and scale numeric data from -10^38+1 to 10^38+1. ntext
This type is used to represent variable-length character data up to a length of 2^30-1 Unicode UCS-2 characters. Use nvarchar_max instead. nvarchar
This type is used to represent variable-length character data up to a length of 4000 Unicode UCS-2 characters. nvarchar_max
This type is used to represent variable-length character data up to a length of 2^30-1 Unicode UCS-2 characters. real
This type is used to represent 32-bit floating precision numbers. smalldatetime
This type is used to represent date and time data from January 1, 1900 to June 6, 2079, with an accuracy of 1 minute. smallint
This type is used to represent 16-bit signed integers. smallmoney
This type is used to represent monetary data values from data values from -214,748.3648 to 214,748.3647. text
This deprecated type is used to represent variable length character data up to a length of 2^31-1 bytes. The number of characters that can be stored depends on the code page of the server. Use varchar_max instead. time
This type is used to represent time data with an accuracy of 100 nanoseconds. tinyint
This type is used to represent numbers between 0 and 255. uniqueidentifier
Uniqueidentifier is used to represent GUIDs. As such, it must be set up like a valid GUID. Example: {B85E62C3-DC56-40C0-852A-49F759AC68FB} varbinary
This type is used to represent variable length binary data up to a length of 8000 bytes. varbinary_max
This type is used to represent variable-length binary data up to a length of 2^31-1 bytes. varchar
This type is used to represent variable length character data up to a length of 8000 bytes. The number of characters that can be stored depends on the code page of the server. varchar_max
This type is used to represent variable-length character data up to a length of 2^31-1 bytes. The number of characters that can be stored depends on the code page of the server. xml
This type is used to represent XML documents and fragments. |
| Index |
The types of indexes and constraints to create for the column, if the table is created. Each index and constraint contains only one column. The valid values for the column type are listed below: PrimaryKey: A primary key with non-nullable and unique constraints. Unique: An index with a unique constraint. NotNull: A non-nullable constraint. |