MSSQL Spatial Writer: User Attributes

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.

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.
  • IndexedNotNull: An index with a non-nullable constraint.
  • Unique: An index with a unique constraint.
  • UniqueClustered: A clustered index with a unique constraint.
  • Clustered: A clustered index without constraints.
  • ClusteredNotNull: A clustered index with a non-nullable constraint.
  • NotNull: A non-nullable constraint.
  • PrimaryKey: A primary key with non-nullable and unique constraints.