Edit Table (SQL Server Compact)

The SQL Server Compact Edit Table dialog box in Server Explorer in Visual Studio lets you modify a table and columns for a SQL Server Compact 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 will create two unique constraints, not a single constraint across both columns.

Primary Key

Specify whether the column is part of a primary key.