Nota
O acesso a esta página requer autorização. Podes tentar iniciar sessão ou mudar de diretório.
O acesso a esta página requer autorização. Podes tentar mudar de diretório.
In Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition), you can access SQL Server Compact Edition 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 SSMSE user interface is a subset of SQL Server Management Studio. SSMSE 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 Edition 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 Edition, you must be familiar with SQL Server, SQL Server Compact Edition, and Transact-SQL, and you must have the following products installed:
- SQL Server
- SQL Server Compact Edition (included with SQL Server)
- Microsoft ActiveSync
- Microsoft .NET Compact Framework
In This Section
| Topic | Description |
|---|---|
Describes Query Editor, the language editor included in SQL Server Management Studio. |
|
Describes templates, which let users easily create scripts for use with SQL Server Compact Edition databases. |
|
Describes using the Show Execution Plan command to see a graphical representation of the execution plan. |