Edit Table (SQL Server Compact Edition)

The SQL Server 2005 Compact Edition (SQL Server Compact Edition) Edit Table dialog box in SQL Server Management Studio and in SQL Server Management Studio Express lets you modify a table and columns for a SQL Server Compact Edition database.

Options

Delete

Click Delete to delete the selected column.

Name

Enter the name of the table.

Column Name

Displays the name of the columns and lets you modify the maximum length and size of the data in the column. You can change the length of the column only for variable-length data types.

Data Type

Displays the type of data that the column can hold. For more information, see "Using Data Types" in SQL Server Books Online.

Length

Displays the size of the column.

Allow Nulls

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

Unique

Displays whether there is a unique constraint defined specifically for the column. If you set the Unique value equal to Yes for two columns, SQL Server Compact Edition will create two unique constraints, not a single constraint across both columns.

Primary Key

Specify whether the column is part of a primary key.