SQL Server - showing extra columns in design view

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:

sql server columns.png

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...

Posted on 31st March 2016 in Technical, SQL Server