Common Database Tasks (SQL Server Compact) | Microsoft Learn

Article
09/27/2010

The following table lists the common database tasks that you must perform to manage Microsoft SQL Server Compact 3.5 databases, and links to topics that describe how to perform these tasks.

Task	Link
Setting the language of the database	LocalConnectionString Property (RDA) CREATE DATABASE (SQL Server Compact) Working with Collations (SQL Server Compact)
Creating a database	How to: Create a Database by Using the Engine Object (Programmatically) How to: Create a SQL Server Compact Database on a Server How to: Create a Database by Using the Replication Object (Programmatically) How to: Create a Database by Using OLE DB (Programmatically)
Opening a database	How to: Set the File Mode when Opening a Database (Programmatically) How to: Set the File Mode when Opening a Database with OLE DB (Programmatically)
Specifying temporary database location	How to: Specify the Location of the Temporary Database by Using ADO.NET (Programmatically) How to: Specify the Location of the Temporary Database by Using the Replication and RDA Objects How to: Specify the Location of the Temporary Database by Using OLE DB (Programmatically)
Deleting a database	How to: Delete a Database (Programmatically)
Maintaining a database	How to: Verify and Repair a Database (Programmatically) How to: Compact a Database (Programmatically) How to: Maintain a Database (SQL Server Management Studio)
Querying a database	How to: View the Execution Plan for a SQL Server Compact Query
Securing a database	How to: Secure a Database (SQL Server Management Studio)

Other Resources

How-to Topics (SQL Server Compact)