Common Database Tasks (SQL Server Compact)

Article
2011-03-24

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

Task	Link
Setting the language of the database	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 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 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 (Visual Studio)
Querying a database	How To: View the Execution Plan for a SQL Server Compact Query
Securing a database	How to: Secure a Database (Visual Studio)

See Also

Other Resources

How-to Topics (SQL Server Compact)