Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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)

share|improve this question
I think the straight answer is "the documentation just isn't up yet" – jcolebrand Jan 14 '11 at 15:30
up vote 3 down vote accepted

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.

share|improve this answer
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:

share|improve this answer
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
@Uwe - If you need portable database, SQLite supports views – Giorgi Jan 19 '11 at 12:59
Thank you, @Giorgi – Uwe Keim Jan 19 '11 at 13:25

There is now a list of features from MS, for Sql Server CE 4.0:

Views are unfortunately not supported

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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