SQL Server - showing extra columns in design view

When designing a table, SQL server has 3 columns (Column Name, Data Type, Allow Nulls), with the rest listed below in a property grid. This can be a bit of an annoyance because description becomes pretty useless hidden down there and Identity information is often missed when firing through a table and data layer set up.

There is a fix however using the registry.

Navigate to (adjusting for your version):
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\12.0\DataProject]

And update the following properties (example):

SSVPropViewColumnsSQL70 to 1,2,6,17,7,8,9,10;
SSVPropViewColumnsSQL80 to 1,2,6,17,7,8,9,10;

To get:

Those comma separated numbers relate to:

1. Column Name
2. Data Type
3. Length
4. Precision
5. Scale
6. Allow Nulls
7. Default Value
8. Identity
9. Identity Seed
10. Identity Increment
11. Row GUID
12. Nullable
13. Condensed Type
14. Not for Replication
15. Formula
16. Collation
17. Description

Source: http://stackoverflow.com/questions/10537610/how-do...