For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes
User attributes for this format are defined below.
| Name | The name of the field to be written. |
| Type |
Choose one of the following field types.  bigint
This type is used to represent 64-bit signed integers. int
This type is used to represent 32-bit signed integers. smallint
This type is used to represent 16-bit signed integers. tinyint
This type is used to represent numbers between 0 and 255. bit
This type is used to represent an integer with a value of 1 or 0. decimal
This type is used to represent fixed precision and scale numeric data from -10^38+1 to 10^38+1. numeric
This type is used to represent fixed precision and scale numeric data from -10^38+1 to 10^38+1. money
This type is used to represent monetary data values from -2^63 to 2^63-1. Attribute values are real numbers such as 55.2354. smallmoney
This type is used to represent monetary data values from -214748.3648 to 214748.3647. Attribute values are real numbers such as 55.2354. float
This type is used to represent 64-bit floating precision numbers. real
This type is used to represent 32-bit floating precision numbers. date
This type is used to represent date data from January 1, 0001 to December 31, 9999. time
This type is used to represent time data with an accuracy of 100 nanoseconds. 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. 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. smalldatetime
This type is used to represent date and time data from January 1, 1900 to June 6, 2079 with an accuracy of one minute. 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. 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. text
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. nchar
This type is used to represent fixed length character data up to a length of 4000 Unicode UCS-2 characters. nvarchar
This type is used to represent variable length character data up to a length of 4000 Unicode UCS-2 characters. ntext
This type is used to represent variable length character data up to a length of 2^30-1 Unicode UCS-2 characters. binary
This type is used to represent fixed length binary data up to a length of 8000 bytes. varbinary
This type is used to represent variable length binary data up to a length of 8000 bytes. image
This type is used to represent variable length binary data up to a length of 2^31-1 bytes. uniqueidentifier
Uniqueidentifier is used to represent GUIDs. As such, it must be set up like a valid GUID. Example: {B85E62C3-DC56-40C0-852A-49F759AC68FB} Note: The {} must be present for the GUID to be written successfully. identity
This type is used to represent an auto-incrementing integer field. If you try to write a value to it; the value will be ignored and the database will simply take the largest integer in the column, increment it and put that number into the field. |
| Index |
The type of index to create for the column. If the table does not previously exist, then upon table creation, a database index of the specified type is created. The database index contains only one column. Note: A given table can contain, at most, one clustered index. The valid values for the column type are listed below: indexed: An index without constraints. indexed_not_null: An index with a non-nullable constraint. unique: An index with a unique constraint. unique_clustered: A clustered index with a unique constraint. clustered: A clustered index without constraints. clustered_not_null: A clustered index with a non-nullable constraint. not_null: A non-nullable constraint. primary_key: A primary key with non-nullable and unique constraints. |