Help with IDENTITY column error

Question

Can anybody help me please where should I define identity for the primary key?

create table Employee(EmployeeID integer IDENTITY (1,1), FirstName varchar(20),

LastName varchar(20),Birthdate date, HomeState varchar(2),

Gender varchar(2), primary key(EmployeeID));

Thank you!

Bharathi Raja · Answer

your Query: create table Employee(EmployeeID integer IDENTITY (1,1), FirstName varchar (20), LastName varchar (20),Birthdate date , HomeState varchar (2), Gender varchar (2), primary key (EmployeeID)); Change The Line: create table Employee(EmployeeID int IDENTITY (1,1), FirstName varchar (20), LastName varchar (20),Birthdate date , HomeState varchar (2), Gender varchar (2), primary key (EmployeeID));

Nigel Fernandes · Answer

This is how your query should be: CREATE TABLE dbo.Employee ( EmployeeID int NOT NULL IDENTITY (1, 1), FirstName varchar (20) NULL , LastName varchar (20) NULL , Birthdate date NULL , HomeState varchar (2) NULL , Gender varchar (2) NULL ) ON [ PRIMARY ] GO ALTER TABLE dbo.Employee ADD CONSTRAINT PK_Employee PRIMARY KEY CLUSTERED ( EmployeeID ) WITH ( STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] GO

Bharathi Raja · Answer

accept the answer

Amit Gupta · Answer

Hey Well, I generally prefer to use a seperate column for identity and primary key named ID Keeping a seperate column will help you to uniquely identify your row for CRUD operations and it doesn't affect your any column. Good Luck

Nel · Answer

Tried but didn't help

Help with IDENTITY column error

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)