Partners
MS SQL Maestro online Help
| Prev | Return to chapter overview | Next |
Setting field parameters
Use the Parameters group to set the field properties described below.
Use the Size edit box to define the length of the field value for integer, float, char and other data types and use Precision to define the precision of the field value, e.g. for float data type.
max
The value applies only to the varchar, nvarchar, and varbinary data types for storing 2^31 bytes of character and binary data, and 2^30 bytes of Unicode data.
Field flags
Not Null
Forbids the NULL values for the field.
Unique
Includes the field into the unique key (index).
Primary Key
With this option checked the field becomes the only field with a primary key. If you check this field, you will not be able to set this attribute for any other field in the table. Hence if you want to create a compound primary key, do not check this field but create a primary key through the Indexes tab of Table Editor or the appropriate step of Create Table Wizard.
Row Guid
Indicates that the new column is a row GUID column.
| Prev | Return to chapter overview | Next |
