can we give the identity for existing column of the table?
(already table contains 10(1-10) unique randam records)
- 2 Answers
- 4083 Views
- I also Faced
- E-Mail Answers
Answer Posted / pravati
ALTER TABLE Tablename
ADD oldcolumnname newcolumnname
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dml command?
Do you know what is normalization of database? What are its benefits?
What does null mean?
What are the basic features of a trigger in ms sql server?
What is logon trigger?
Mention the differences between local and global temporary tables.
What are date and time data types in ms sql server?
What is recompile sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What are points to remember while using the fillfactor argument?
what stored procedure would you use to view lock information? : Sql server administration
Explain system scalar functions?
What are the differences between substr and charindex in sql server.
What is PROJECTION Operation?
How to set database to be read_only in ms sql server?
