Choosing columns for display in Table Designer
Currently in table designer the available columns for creating tables are Column Name, Data Type, and Allow Nulls. It would be much easier to have certain columns such as Allow Nulls, Identity Column, Seed, and Increment also on those columns, as it would make my table development time faster.
Upvotes: 3<=-=Mar 31 2006 8:20AM=-=>
Quick update. We are placing this bug report under consideration for SP2.<=-=Apr 19 2006 11:32AM=-=>
Thank you for your feedback – we will consider this for a futre release of SQL Server.<=-=May 12 2011 4:07AM=-=>
We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.
Thanks for writing in to Microsoft.
Shawn Clabough commented
I also would like frequently used properties to be added to the designer grid. it would be very handy to be able to set properties like "Computed Column Formula", "Indentity Specification (Is Identity)", and "Default Value" directly in the grid rather than having to go down to the Column Properties area then expand the needed property, then select the desired option.