Common Database Tasks (SQL Server Compact Edition)

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

Task	Link
Setting the language of the database	LocalConnectionString Property (SQL Server Compact Edition) CREATE DATABASE (SQL Server Compact Edition)
Creating a database	How to: Create a SQL Server Compact Edition Database by Using the Engine Object (Programmatically) How to: Create a SQL Server Compact Edition Database on a Server How to: Create a SQL Server Compact Edition 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 SQL Server Compact Edition Database (Programmatically) How to: Compact a Database (Programmatically) How to: Shrink 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 Edition Query
Securing a Database	How to: Secure a Database (SQL Server Management Studio)

See Also

Other Resources

How To (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance

Last updated on 2007-06-28