Blog

Create table

SQL

Create table

SQL command to create table with identity and primary key constraint

				
					CREATE  TABLE EMPLOYEE 
(
 EmployeeId INT IDENTITY(1,1) NOT NULL,
 FirstName VARCHAR(20),
 LastName VARCHAR(20),
 Age INT,
 CONSTRAINT PK_EmployeeId PRIMARY KEY CLUSTERED (EmployeeId)
)
				
			

Please comment and share if you like this post and tell us about how we can enhance our posts. Thanks.

Subhajit