Add/Edit field
When you import data with destination table creation, you can manage this table's fields.
Use the context menu to Add/Edit/Drop a field.
Selecting Add field or Edit field context menu item opens the field editor that allows you to view/edit the properties of the destination table fields.
Use the Column edit box to set the field name. Note that the name of the field must be unique among all the field names in the table.
The Type tab defines the type of the field data.
Size
Defines the size of the field value.
Scale
For numeric and decimal types you need to define the number of decimal to the right of the decimal point.
Default value
Define this option value if you need inserted records to get specified value.
Seed
Specify the value used for the first row that is loaded into the table.
Increment
Specify the value added to the identity value of the previous row that is loaded.
Not NULL
Check this option to prevent the entry of NULL or unknown values in column.
Is Row Guid
This option specifies that the ROWGUIDCOL property is added to the column. ROWGUIDCOL indicates that the column is a row GUID column.
Identity
This option specifies that the new column is an identity column.
Not for replication
This option allows you to specify that the Identity property should not be enabled when a replication agent modifies the table that contains the identity column.