Just read about the release of SQL Server CE 4 and then searched all through their product website, I still cannot find a feature overview.

Previous versions of SQL Server CE didn't support views, I was hoping that they removed the limitations.

My question is:

Is there a page which lists the features and limitations of SQL Server CE 4?

(Edit: I found this feature comparison for 3.5, but not for 4.0)

  • 1
    I think the straight answer is "the documentation just isn't up yet" – jcolebrand Jan 14 '11 at 15:30

I installed WebMatrix w/ CE 4.0 last night. I can't confirm for sure that CE 4.0 can't do views, but I can tell you that there's no support for creating them in WebMatrix.

  • 1
    I'm also not able to create views on a CE database using VS2010. – D. Lambert Jan 14 '11 at 21:35

The closest I can find to an answer from MS... at least one of their moderators: http://social.msdn.microsoft.com/Forums/en/sqlce/thread/8b18e08b-c345-4f6d-98fd-2273c933ea2b

  • Thank you! Too bad, at least Views would have enabled my to migrate old MDB Access projects to SQL CE... – Uwe Keim Jan 16 '11 at 10:25
  • 1
    @Uwe - If you need portable database, SQLite supports views – Giorgi Jan 19 '11 at 12:59

There is now a list of features from MS, for Sql Server CE 4.0: http://msdn.microsoft.com/en-us/library/bb896140.aspx

Views are unfortunately not supported

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.