Online Documentation for SQL Manager for SQL server
Setting field name and type
Column name
Enter a name for the new field, or modify the name of the field being edited. Note that the name of a field must be unique among all the field names in the table.
The Data type tab defines the type of the field data.
Column type kind
This group allows you to select whether the field being created/edited is based on a standard data type, a user-defined type, or is a computed column.
Standard data type
Specifies that the field is based upon a built-in SQL Server data type.
Type
Here you can set the field type by selecting it from the drop-down list of the standard SQL Server data types.
Size
Specify the size value (for certain types). Check the Maximum size option to use the maximum values set by SQL Server.
Scale
Defines the maximum number of decimal digits that can be stored to the right of the decimal point of the value (for numeric and decimal data types).
Collation
Use the drop-down list to specify the collation for text and char columns. By default, the column is assigned the default collation of the database.
Not NULL
Check this option to specify that the values for the column should never contain a null value. NOT NULL affects all INSERT and UPDATE operations on a column.
RowGuid
This option specifies that the ROWGUIDCOL property is added to the column. ROWGUIDCOL indicates that the column is a row GUID column.
Primary key
Check this option to include the field into the primary key. Note that if you include a field to a primary key, you should also make it Not Null.
A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. This column, or columns, is called the primary key (PK) of the table and enforces integrity of the table.
Unique key
Check this option to create a unique key on the field that provides entity integrity for a particular column or columns using a unique index.
Sparse
Check this option to make the column a Sparse column. Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve non-null values.
Filestream
Check this option to store the data from this column in the Filestream filegroup. This option is available if any filestream file group is specified for the table.
Online
Check this option to enable ONLINE mode on field modification.
User-defined data type
Specifies that the field is based upon a user-defined data type.
Type
Use the drop-down list to select the user-defined type for the field being created/edited.
Computed
Specifies that the field is computed from an expression that can use other columns in the same table.
Store computed values in table
This option determines whether computed values are stored in the table or the column is not physically stored in the table.
Specify an expression that defines the value of the computed column. For example, a computed column can have the following definition:
cost AS price * qty.
The expression can be a noncomputed column name, constant, function, variable, and any combination of these connected by one or more operators. The expression cannot be a subquery or include an alias data type.