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

Why truncate is ddl command?

1066

What is the full meaning of dml?

952

What is coalesce in sql server?

1052

How to trouble shoot if unable to connect SQL Server

1992

Is the order of columns in the set clause important in ms sql server?

970

What are the differences between substr and charindex in sql server.

1115

What is bcp? When does it used?

976

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1059

What happens if null values are involved in datetime operations?

975

what protocol both networks use? : Sql server database administration

971

Explain the microsoft sql server delete command?

1024

What is inline variable assignment?

1029

What are the differences between sql server and mysql.

1098

What is the maximum number of index per table?

1073

What objects does the fn_my_permissions function reports on? : sql server security

1035