ALTER TABLE Tablename ADD oldcolumnname newcolumnname

can we give the identity for existing column of the table?
(already table contains 10(1-10) unique randam records)

Question Posted / pravati

Answer Posted / pravati

ALTER TABLE Tablename
ADD oldcolumnname newcolumnname

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain four layers of abstraction microsoft architectured?

147

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1141

How to configure and test odbc dsn settings?

1225

Why we need sql server?

1015

What is an indexing strategy?

1069

What are the new features in sql server 2016?

1033

What is difference between createstatement and preparedstatement?

1176

what exactly sql injuction.how to overcome.....

2595

How to call a function from a stored procedure in SQL Server ?

1086

What is transactional replication?

1021

What is wrong with sql server client libarary dll, ntwdblib.dll?

1092

What is SQL Server?

1271

Define left outer join in sql server joins?

1011

How are the unique and primary key constraints different?

1127

What are three major types of constraints?

1174