Overview of Databases (SQL Server Compact Edition)
You can create or connect to a Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) database on a device or on a desktop computer.
A SQL Server Compact Edition database is stored in a file with the .sdf extension. The file contains the complete contents of the database and can be up to 4 GB. SQL Server Compact Edition can access and modify the database file, both on a smart device and on a Tablet PC. It also supports use on desktop computers by using SQL Server Management Studio and other tools.
By using either SQL Server Management Studio or Transact-SQL statements, you can connect to an existing database on a desktop. You can also create and modify databases from a desktop. You can then view the design of that database in a tree hierarchy by using the object tree. Each node has a shortcut menu with commands for modifying the database or retrieving information about the database.
Some of the functions you can perform in a SQL Server Compact Edition database include the following:
Creating, deleting, and editing tables and the associated data.
Creating, maintaining, and deleting indexes.
Examining information schema views and data types.
Initiating replication and remote data access (RDA) synchronization.
You can use Transact-SQL commands, including data manipulation language (DML), data definition language (DDL), and functions, with the SQL Server Compact Edition database.
You can also use replication or RDA with a database that is exposed through native and managed APIs.