SQL

To Add an Identity Column to an Existing Table

ALTER TABLE <Table_Name> ADD <Column_Name>  <DataType> IDENTITY(1,1)

Eg : ALTER TABLE EMP ADD EmpID INT IDENTITY(1,1)

————————————————————————————————————————————

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s