• I will put table definition you will get clear picture..

    I have a table : test with column A, B and C with datatype int

    test(A int, B int, C int)........ here A is primary key.

    We have some data in this table. Now I want to make A as identity.