Table Design (Column Properties)

This area allows you to view/edit the detailed properties for the column selected in the column list.

The individual properties will be enabled depending on datatype (eg a non-numeric column cannot be set as the Identity column).

Description
Shows the text description of the selected column.

Default
Shows the default for this column whenever a row with a null value for this column is inserted into the table. The value of this field can be either the value of a SQL Server default constraint or the name of a global constraint to which the column is bound. The browse button allows you to select a pre-defined default, a built-in function, or enter a value directly as text.

Precision
Shows the maximum number of digits for values of this column.

Scale
Shows the maximum number of digits that can appear to the right of the decimal point for values of this column.

Identity
Shows whether the column is used by SQL Server as an identifier column. Possible values are:

No	The column is not used as an identity column.
Yes	The column is used as an identity column.
Yes (Not For Replication)	The column is used as an identity column, except while a replication agent is inserting data into the table.

Identity Seed
Shows the seed value of an identity column. This option applies only to columns whose Identity option is set to Yes or Yes (Not For Replication).

Identity Increment
Shows the increment value of an identity column. This option applies only to columns whose Identity option is set to Yes or Yes (Not For Replication).

Is RowGuid
Shows whether the column is used by SQL Server as a ROWGUID column. You can set this value to Yes only for a column that is an identity column.

Formula
Shows the formula for a computed column.

Collation
Shows the collating sequence that SQL Server applies by default to the column whenever the column values are used to sort rows of a query result.