Is there a way to make Identity Specification show up in the table designer next to the Allow Nulls column?

I would like to be able to see the Identity Specification (not as worried about seed/increment) and hate having to scroll around on the column properties panel.

Is it possible to add a column next to Allow Nulls in the table designer for Identity Specification? Specifically I am concerned with MS SQL M开发者_JS百科anagement Studio 2008.

Not exactly what you wanted but you can do it on a database diagram by right clicking the table -> Table View -> Custom and Modifying Custom to include the Identity Specification.

I usually script the table to see all its properties. There are other things that are better vissible when a table is scripted as opposed to opened in designer, like keys and exact constraint definitions. I would recommend that you look at tables in their native format, not wrapped by designer.