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.

 

RadioButton Standard data type

Specifies that the field is based upon a built-in SQL Server data type.

 

Field Editor - Setting field name and type - Standard

 

 

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 CheckBox 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.

 

CheckBox 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.

 

CheckBox RowGuid

This option specifies that the ROWGUIDCOL property is added to the column. ROWGUIDCOL indicates that the column is a row GUID column.

 

CheckBox 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.

 

CheckBox 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.

 

CheckBox 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.

 

CheckBox 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.

 

CheckBox Online

Check this option to enable ONLINE mode on field modification.

 

RadioButton 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.

 

RadioButton Computed

Specifies that the field is computed from an expression that can use other columns in the same table.

 

Field Editor - Setting field name and type - Computed

 

 

CheckBox 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.