Is SQL Server Compact Edition a full relational database?
Yes. It provides full referential integrity, including support for cascading deletes and multiple column indexes. It also supports transactions, including the ability to commit and roll back database changes. However, it doesn’t support stored procedures. Data files can be encrypted using RSA 128-bit encryption.