| Name
|
The name of the field to be written. |
| Type
|
Choose one of the following field types.
 bigint
This type is used to represent 64-bit signed integers.
binary
This type is used to represent fixed-length binary data up to a length of 8000 bytes.
bit
This type is used to represent an integer with a value of 1 or 0.
char
This type is used to represent fixed-length character data up to a length of 8000 bytes.
The number of characters that can be stored depends on the code page of the server.
float
This type is used to represent 64-bit floating precision numbers.
image
This type is used to represent variable length binary data up to a length of 2^31-1 bytes.
Use varbinary_max instead.
integer
This type is used to represent 32-bit signed integers.
money
This type is used to represent monetary data values from -922,337,203,685,477.5808 to 922,337,203,685,477.5807.
nchar
This type is used to represent fixed-length character data up to a length of 4000 Unicode UCS-2 characters.
numeric
This type is used to represent fixed precision and scale numeric data from -10^38+1 to 10^38+1.
ntext
This type is used to represent variable-length character data up to a length of 2^30-1 Unicode UCS-2 characters.
Use nvarchar_max instead.
nvarchar
This type is used to represent variable-length character data up to a length of 4000 Unicode UCS-2 characters.
nvarchar_max
This type is used to represent variable-length character data up to a length of 2^30-1 Unicode UCS-2 characters.
real
This type is used to represent 32-bit floating precision numbers.
smallint
This type is used to represent 16-bit signed integers.
smallmoney
This type is used to represent monetary data values from data values from -214,748.3648 to 214,748.3647.
text
This deprecated type is used to represent variable length character data up to a length of 2^31-1 bytes. The number of characters that can be stored depends on the code page of the server.
Use varchar_max instead.
tinyint
This type is used to represent numbers between 0 and 255.
uniqueidentifier
Uniqueidentifier is used to represent GUIDs.
As such, it must be set up like a valid GUID. Example: {B85E62C3-DC56-40C0-852A-49F759AC68FB}
varbinary
This type is used to represent variable length binary data up to a length of 8000 bytes.
varbinary_max
This type is used to represent variable-length binary data up to a length of 2^31-1 bytes.
varchar
This type is used to represent variable length character data up to a length of 8000 bytes.
The number of characters that can be stored depends on the code page of the server.
varchar_max
This type is used to represent variable-length character data up to a length of 2^31-1 bytes.
The number of characters that can be stored depends on the code page of the server.
xml
This type is used to represent XML documents and fragments.
|
| Index
|
The types of indexes and constraints to create for the column, if the table is created.
Each index and constraint contains only one column.
The valid values for the column type are listed below:
PrimaryKey: A primary key with non-nullable and unique constraints.
Unique: An index with a unique constraint.
NotNull: A non-nullable constraint.
|