Common Database Tasks (SQL Server Compact)

The following table lists the common database tasks that you must perform to manage Microsoft SQL Server Compact 3.5 (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)

See Also

Other Resources

How-to Topics (SQL Server Compact)

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)

Last updated on 2009-09-28