New Table

  • Article

The SQL Server Compact 4.0 New Table dialog box in Server Explorer in Visual Studio lets you create a new table with columns for a SQL Server Compact 4.0 database.

Options

Delete

Click Delete to delete this table.

Name

Enter the name of the table.

Column Name

Displays the name of the columns in 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. Values can be Yes or 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 4.0 will create two unique constraints, and not a single constraint across both columns.

Primary Key

Specify whether the column is a primary key.