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.
精彩评论