Hello all, how does one programmaticly create a table in sql ce and assign the primary key, identity, identityincrement, and identityseed? strsql = "create table flags flagid int(4), userid int(4), flagname nvarchar(100)" i want to assign flagid to be the primary key, with identity to true and defaults of increment (1), seed (1). Let's say the table definition is the following: create table beer ( beer_id numeric(10) not null, mnemonic nvarchar(8) ); go let's say that i want the new identities to temporarily start at 12345, and at the end delete the new rows and set the next identity to what it would have been.. Should read insert into #temp (myid, myname) as you have listed 3 fields to insert but only entered 2 fields, as you are using an identity field you need not enter a value for this..
