• Article

In SQL Server Compact 3.5, you can access SQL Server Compact 3.5 databases stored on a smart device or on the desktop computer by using SQL Server Management Studio in SQL Server or SQL Server Management Studio Express (SSMSE). The SQL Server Management Studio Express user interface is a subset of SQL Server Management Studio. SQL Server Management Studio Express is a free download from the Web.

SQL Server Management Studio is a suite of administrative tools for managing the components that belong to SQL Server. This integrated environment allows users to perform a variety of tasks within a single interface, such as backing up data, editing queries, and automating common functions.

The following SQL Server Management Studio components integrate access to SQL Server Compact 3.5 objects and features. 

  • Object Explorer—for locating, modifying, scripting, or running objects in a SQL Server database.

  • Query Editor—for writing and editing scripts in SQL.

  • Template Browser—for locating and scripting templates.

  • Show Execution Plan—for viewing a graphical representation of a query's execution plan.

To use SQL Server Management Studio features with SQL Server Compact 3.5, you must be familiar with SQL Server, SQL Server Compact 3.5, and Transact-SQL, and you must have the following products installed. 

  • SQL Server

  • SQL Server Compact 3.5 (included with SQL Server)

  • Microsoft ActiveSync

  • Microsoft .NET Compact Framework

In This Section

Topic

Description

Querying SQL Server Compact Database Data

Describes Query Editor, the language editor included in SQL Server Management Studio.

Locating and Scripting Templates

Describes templates, which let users easily create scripts for use with SQL Server Compact 3.5 databases.

Display Execution Plan for a Query

Describes using the Show Execution Plan command to see a graphical representation of the execution plan.