You are here: New Formats for 2016+Microsoft Access JDBC Reader/WriterWriter Feature Type Properties: User Attributes

Microsoft Access (JDBC) Writer: User Attributes

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.

Index

The types of indexes and constraints to create for the column, if the table is created.

Indexes and constraints are only created 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.