When creating a new table, you can't set the planned identity field without saving, even if it meets the criteria.
This error is prompted.
Steps to reproduce
- Create a new table
- Create a column called ID, Numeric, size 9.0
- Change property "is identity" to "True"
- Get the above error, even though it has no decimals.
Work around
Save the table, then make identity, and save again. But this is not obvious at first.