I understand distinction. In my case the column is Primary key. But I want to make it an Identity (in code) (if not yet identity).
Thank you.
>One thing you need to keep in mind. Identity is not PrimaryKey and can have duplicates. If you want the column to be a PK, you need to set that after making it Identity.
>
>>The code (above that checks if a table has identity) works. How do I change it if I want to include the column name. That is, if I want to know if a certain column in table 'items' is identity?
>>
>>On the last point, I do want to preserve the current value in the column before making it an identity. From this point, the column value will be incremented then. So I do not want to recreate the table.
>>
>>Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham