EMS logo

Products Navigation

Data Pump for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Pump for SQL Server

On-line Documentation

Target field properties


The Target object definition area of Step 5 allows you to view and edit the target iconObjects_Field field properties:

 

Step 5 - Editing target objects - Target field properties

 

Name - specifies the field name

 

Type - use the drop-down list of data types supported by SQL Server to select the one you wish to be applied to the currently selected field

 

Size - set the size of the field (for string types)

 

Scale - specify the scale for the field values (if available for the selected data type)

 

Default value - enter the value that inserted records will get by default (if necessary)

 

Comment

If necessary, add a comment for the object.

 

CheckBox Not NULL - determines nullability for the field (whether the field is NULL / NOT NULL)

 

CheckBox Is Row Guid - specifies that the ROWGUIDCOL property is added to the column. ROWGUIDCOL indicates that the column is a row GUID column

 

CheckBox Identity - specifies that the new column is an identity column

 

Seed - the value used for the first row that is loaded into the table

 

Increment - the value added to the identity value of the previous row that is loaded

 

CheckBox Not for replication - specifies that the Identity property should not be enabled when a replication agent modifies the table that contains the identity column

 

<< Back to editing target objects