Create SQL Syntax for table with identity field getting error parameter is incorrect
Posted on 2005-04-24
i have the database schema and have code to create the databases on the fly.
i have everything working but for the life of me can't get the identity field to create.
I am trying to run the following command.
create table Member(ID integer identity, Email varchar(255) not null)
i continue to get the error parameter is incorrect
create table Member(ID integer identity(1,1) not null, Email varchar(255) not null)
have also tried
alter table member add field Id integer identity.
i am at a lost. everything i read says this should work