Using Query Tools (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) uses SQL Server Management Studio on the desktop and SQL Server Compact Edition Query Analyzer on the supported devices to access and query data. SQL Server Management Studio and SQL Server Compact Edition Query Analyzer can be used to do the following:

• Create databases.
• Manage and connect to other databases on a device.
• Verify remote data access (RDA) and replication applications.
• Create and modify tables and indexes in a database.
• Query objects by using the SELECT statement.
• Insert and delete rows in a table.
• Modify existing data in a table.
• Compact and repair a database.

SQL Server Management Studio

SQL Server Management Studio is a suite of administrative tools for managing the components that belong to SQL Server. This integrated environment lets users perform a variety of tasks, such as backing up data, modifying queries, and automating common functions within a single interface. You can use the SQL Editor tool (referred to as SQL Query Analyzer in earlier versions of SQL Server) from within Management Studio.

SQL Server Compact Edition Query Analyzer

SQL Server Compact Edition Query Analyzer is a graphical tool that runs on supported devices. It is installed when SQL Server Compact Edition is installed on a device.

In This Section

See Also

Tasks

How to: Install Query Analyzer (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance