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 |
This section describes the attribute types for a table. bigdatetime This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with microsecond precision. See Standard FME Date and Time Format. bigint This type is used to represent 64-bit signed integers. bigtime This type is used to represent time data with microsecond precision. See Standard FME Date and Time Format. binary This type is used to represent fixed length binary data up to a length of 255 bytes. bit This type is used to represent the logical values true and false. Bit columns cannot be null and cannot have indexes specified. char This type is used to represent fixed length character data. date This type is used to represent date data from January 1, 0001 to December 31, 9999. See Standard FME Date and Time Format. datetime This type is used to represent date and time data from January 1, 1753 to December 31, 9999 with up to 1/300 second precision. See Standard FME Date and Time Format. decimal This type is used to represent numeric data with a precision and scale of up to 38 digits. double This type is used to represent 64-bit floating precision numeric data. image This type is used to represent binary data up to a length of 2^31-1 bytes. int This type is used to represent 32-bit signed integers. money This type is used to represent monetary values between -922,337,203,685,477.5808 and 922,337,203,685,477.5807. nchar This type is used to represent fixed length multibyte character data. numeric This type is used to represent numeric data with a precision and scale of up to 38 digits. The decimal and numeric types are identical with the exception that a numeric column with a scale of 0 can be specified as an IDENTITY column. nvarchar This type is used to represent variable length multibyte character data. real This type is used to represent 32-bit floating precision numeric data. smalldatetime This type is used to represent date and time data from January 1, 1900 to June 6, 2079 with minute precision. See Standard FME Date and Time Format. smallint This type is used to represent 16-bit signed integers. smallmoney This type is used to represent monetary values between -214,748.3648 and 214,748.3647. text This type is used to represent character data up to a length of 2,147,483,647 bytes. time This type is used to represent time data with millisecond precision. See Standard FME Date and Time Format. tinyint This type is used to represent integers between 0 and 255. unichar This type is used to represent fixed length Unicode character data. univarchar This type is used to represent variable length Unicode character data. unsigned bigint This type is used to represent 64-bit unsigned integers. unsigned int This type is used to represent 32-bit unsigned integers. unsigned smallint This type is used to represent 16-bit unsigned integers. varbinary This type is used to represent variable length binary data up to a length of 255 bytes. varchar This type is used to represent variable length character data. |
| 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: This type specifies that the column is a primary key for the table. Only one primary key is allowed per table. Unique: This type specifies that the column has a UNIQUE constraint. NotNull: A non-nullable constraint. Null: A nullable constraint. |