Column Properties

The Column Properties dialog box in Server Explorer in Visual Studio displays the properties for each column in the SQL Server Compact database.

Options

Key

Indicates whether the column is part of primary key.

Name

Displays the name of the column.

Data Type

Displays the type of data that the column can hold. For more information, see Data Types.

Size

Displays the size of the column.

Identity

Displays whether the column is the identity column for the table. Permissible values are Yes and No.

Nulls

Displays whether the column accepts null values. Permissible values are Yes and No.

Default

Displays the SQL Server Compact default bound to the column.