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

What is the filtered index?

1054

How do I setup a local sql server database?

1004

Give me a SQL Query to find out the second largest company?

1165

How to create view in stored procedure sql server?

1015

Define tempdb database?

993

What is reportserver and reportservertempdb ?

152

Explain for xml explicit mode?

974

What is the difference between substr and charindex in the sql server?

1101

Why truncate is ddl command?

1063

Explain identity in sql server?

1005

How can I know what locks are running on which resource?

953

What is 2nf normalization?

1021

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

Explain what are the authentication modes in sql server?

1012

query processing

2164