Column Properties

2016 (13.x) and later versions

Azure

SQL Managed Instance

Analytics Platform System (PDW)

Use this page to view properties for the selected column.

Information on this page is read-only. To modify the column, close the

dialog box, expand the table and columns in Object Explorer, right-click the column, and then

click.

The name of the column.

The type of data that the column can hold. If the data type is a user-defined data type, the

user-defined data type is displayed. If the data type is not a user-defined data type, then the

system data type is displayed. For more information, see

Data Types (Transact-SQL).

The type of data that the column can hold. If the data type is a system data type, then the

system data type is displayed. If the data type is a user-defined data type, the system data type

that makes up the user-defined data type is displayed.

Indicates whether the column is a primary key. Possible values are

and.

Indicates whether the column accepts null values. Possible values are

and.

Indicates whether the column value is the result of a computed expression.

Indicates the statement used to compute the column text. For more information,

Specify

Computed Columns in a Table.

Indicates whether the column is the identity column for the table. Possible values are

and.