title: The constraint specified is not valid
body: <p>I have a local (compact 3.5) sql database file which I am currently trying querying using a program called Compact Query. I am trying to create two tables using SQL - here is the code:</p>
  
  <pre><code>CREATE TABLE List(
  ListId int IDENTITY(1,1) NOT NULL,
  ShortDesc varchar(50) NOT NULL,
  ActiveInd bit NULL,
  CONSTRAINT PK_List PRIMARY KEY CLUSTERED
  (
  ListId ASC
  ))
  
  CREATE TABLE CustomerList(
  CustomerListId int IDENTITY(1,1) NOT NULL,
  CustomerId int NULL,
  ListId int NULL,
  CONSTRAINT PK_CustomerList PRIMARY KEY CLUSTERED
  (
  CustomerListId ASC
  ))
  </code></pre>
  
  <p>When I run this SQL, it returns the following error:</p>
  
  <pre><code>The constraint specified is not valid. [0, 0, 0,,,]
  </code></pre>
  
  <p>Any ideas?</p>