New Table

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

Options

Delete

Click Delete to delete this table.

Name

Enter the name of the table.

Column Name

Displays the name of the columns within the table.

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

Specify whether the column has a unique constraint. The unique constraint applies only for individual columns. If you set the Unique value equal to Yes for two columns, SQL Server Compact Edition will create two unique constraints, and not a single constraint across both columns.

Primary Key

Specify whether the column is a primary key.