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.