Jaa

Column Properties

  • Artikkeli

The Column Properties dialog box in SQL Server Management Studio and SQL Server Management Studio Express displays the properties for each column in the Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) 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 Edition default bound to the column.