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.