Provide an ALTER COLUMN syntax to add or remove the IDENTITY property of a column. This will allow an IDENTITY to be changed without dropping and recreating the table.
This is not only a convenience but is actually important for some scenarios:
1. Suppose the SELECT INTO was used to create the table. SELECT INTO is fast, but subsequently recreating the table just to setup the IDENTITY negates a lot of SELECT INTO's speed.
2. If the table is involved in replication, it is not possible to drop and recreate it.
A similar suggestion in Microsoft Connect involves the ability to MOVE columns, see 124781.