CODECUBE VENTURES

SQL Server CE doesn't like []

This fails "DROP TABLE [People]" but this doesn't "DROP TABLE People"

I thought that was standard sql, but I guess I was wrong. come to think of it ... It must not be because another RDBMS (FireBird) requires that you put double quotes around object names.

ie. DROP TABLE "People"

Quirky ass databases ... this killed at least an hour of my time :-(

Latest post: Digging Up the First Version of CodeCube

See more in the archives