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 partitioned view?

1054

What is the xml datatype?

1028

What is the difference between varchar and varchar types?

1058

Can I save my report as html, excel or word? : sql server management studio

932

Explain database normalization?

1200

What is a livelock?

943

What is the difference between deallocate cursor and close cursor?

1229

What are the types of joins in sql?

1101

Explain what are the basic functions for master, msdb, model, tempdb databases?

951

How to list all objects in a given schema?

1038

What are “lock” hints?

1045

what are constraints? Explain different types of constraints? : Sql server database administration

958

What is the difference between primary key and unique constraints?

940

How to execute a sql statement using odbc_exec()?

1117

How can you find out which stored procedures are recompiling?

909