When creating a new table, you can't set the planned identity field without saving, even if it meets the criteria.

Click image for larger version. 

Name:	id_on_create.png 
Views:	121 
Size:	12.7 KB 
ID:	15284

This error is prompted.

Steps to reproduce
  1. Create a new table
  2. Create a column called ID, Numeric, size 9.0
  3. Change property "is identity" to "True"
  4. 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.