I just not created a new database with 2 tables in it. In a table, I have set a column as a primary key and trying to change its properties i.e. setting is Identity to YES, but am not able to do so. Any ideas/suggestions?

Make sure the datatype is <code>int</code> and not something else. You can't have an identity on a different type.

Not able to set is Identity key as Yes in SQL Server

Make sure the datatype is int and not something else.

You can't have an identity on a different type.

123

answered Jan 05 '23 03:01

Do you have data in the table? You can't make an IDENTITY column if you do.

answered Jan 05 '23 03:01

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!