Creating a Table Using Sql Server Compact 3.5. Using SqlServer Management Studio Express

"The following steps help you to create a table in Sql Server Comapct Edition 3.5."

1. Open the Sql Server Management Studio Express, by clicking on start button on taskbar, select Programm, and then click on Sql Server Management Studio Express, the Sql Server Management Studio Express dialog box appears

2. Select the Sql Server Compact Edition form the Server Type drop down list.

3. Click on the Database File Drop down list and select the New Database, another dialogbox appears, for configuraing the database

which looks similar to this

4.Cick on the browse button and choose the path where you want to save the database file. By default the extension of the database file is .sdf

5. Set the password, if required, otherwise click on the Ok button, a warning message appers.

6.Click on yes to continue or on No to go back to the Change the password.

7.Finally click on the connect button. Now the Sql Server Compact 3.5. is connected.

8. Click on the New Query from the Toolbar,

9. Write the script.

Scripting for creating a table

create table employee

(

EmpId bigint primary key identity(1,1) not null,

address nvarchar(100) not null,

J_O_D datetime not null,

Status nvarchar(4000)

)

11.Select the script and press F5 function key,

A script executed successfully is displayed.