Microsoft SQL Server Compact 3.5 Query Analyzer is a graphical tool included in SQL Server Compact 3.5 that you can use to perform the following tasks:
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.
To navigate the graphical interface and execute commands in SQL Server Compact 3.5 Query Analyzer on a device, you must use a stylus. However, when the device is connected to a desktop computer, the desktop keyboard and mouse can be used in conjunction with Microsoft Remote Display Control for Windows CE. Also, SQL Server Compact 3.5 Query Analyzer is not available with Smart Phone 2005.
Describes the elements of the SQL Server Compact 3.5 query window.
Describes how to perform database connection and management tasks.
Describes how to work with database objects.
Describes how to execute SQL statements.