Working with Databases (SQL Server Compact)

Microsoft SQL Server Compact offers various features to create, access, modify, secure, query, and maintain databases.

Topic

Description

Overview of Databases (SQL Server Compact)

Provides an overview of SQL Server Compact databases.

Overview of Database Engine (SQL Server Compact)

Introduces the SQL Server Compact Database Engine and how it is used.

Understanding Databases (SQL Server Compact)

Describes database objects, data types and temporary databases.

Using and Maintaining Databases (SQL Server Compact)

Describes how to perform common database tasks and how to maintain a SQL Server Compact database.

Securing Databases (SQL Server Compact)

Describes how to protect databases by using passwords and encryption.

Accessing and Modifying Databases (SQL Server Compact)

Describes the intricacies of the SQL Server Compact Database Engine, including transactions, locking, multiuser access, and cursors.

Querying Databases (SQL Server Compact)

Describes the options for querying and modifying data.

International Considerations (SQL Server Compact)

Describes the international considerations for SQL Server Compact.

Managing 64-bit Database Applications

Describes requirements for managing 64-bit SQL Server Compact databases.