Hi Friends ,

i am having an table with Lots of Data ,

now i want to Remove Identity Property for my Custom Needs,

Is there any Way to remove Identity Property from the  Column  and Still i need the table with all the  data ,

Please provide all the Possible Way to Remove.

Please let me know if you did't understand the question.

Regards

Ravikumar C

 

 

 

 

1.Create one temp table without identity property.
2.Copy data from original table to temp table.
3.drop the original table.
4.Rename the temp file

-Selvaraj

i think u can use the "alter table" statement
check it out
maybe it will help u
good luck


RAQ Report
www.raqsoft.com

---

RAQ Report
www.raqsoft.com

alter command is not possible to remove identity property.

-Selvaraj

I am so sorry,I can't help you,you may get help from other posts

jaja,I am really to focus my attention on your post.

Alter command is not possible to remove identity property......

---

I think you can use the "ALTER TABLE" statement.

Thanks for the help. Going to solve it.

---

fastest way to make a website