Search code examples
sqlsql-server-ce

There was an error parsing the query. [ Token line number] sql error while creating table

Hi guys im tryin to create tables in sql compact.

Here is the query:

CREATE TABLE [dbo.A] 
(
    Id nvarchar(37) NOT NULL CONSTRAINT Info_PK PRIMARY KEY,
    ImportDate datetime NOT NULL        
);

CREATE TABLE [dbo.B]
(
    Id uniqueidentifier PRIMARY KEY,
        DeviceId smallint,

);

But it is giving error in the line where it is tryin to create table B.

Solution

  • Don't use dbo. Schemas are not supported in SQL CE. And you may need execute your queries separately.

    Here is a similar problem and the solution: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/d6f1db96-8724-4376-990e-3f6da18c2d08/