Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: 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 section describes the attribute types for a table.  alphanum
Represents strings of up to 127 alpha-numeric characters. bigint
Represents 64-bit signed integers. bintext
Represents a large-object that can hold character strings or binary data. This type is only supported in column tables. blob
Represents variable-length binary data up to a length of 2 GB. clob
Represents variable-length ASCII character data up to a length of 2 GB. date
Represents date data from January 1, 0001 to December 31, 9999. decimal
Represents fixed precision and scale numeric data. double
Represents 64-bit floating precision numbers. integer
Represents 32-bit signed integers. nclob
Represents variable-length Unicode character data up to a length of 2 GB. nvarchar
Represents variable-length Unicode character data up to a length of 5000 characters. real
Represents 32-bit floating precision numbers. seconddate
Represents date and time data from January 1, 1900 to June 6, 2079 with an accuracy of one second. smallint
Represents 16-bit signed integers. shorttext
Represents a variable-length character string. It is only supported for column tables. text
Represents a large-object character string. It is only supported for column tables. st_geometry
This type is used to store geometry of one or more types. st_point
This type is used to store 2D points. time
This type is used to represent time data with an accuracy of up to one second. timestamp
This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with an accuracy of up to 100 nanoseconds. tinyint
This type is used to represent numbers between 0 and 255. varchar
This type is used to represent variable-length ASCII character data up to a length of 5000 bytes. varbinary
This type is used to represent variable-length binary data up to a length of 5000 bytes. |
| Index |
This type is used to create bitmap indexes. A bitmap index stores a bitmap for each index key. Each index key stores pointers to multiple rows. They are primarily designed for data warehousing or environments in which queries reference many columns in an ad hoc fashion. Indexes and constraints are only created if the table is created. 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. UniqueNotNull: An index with a non-nullable and unique constraints. |