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

Comments

No comments yet.

Leave a reply

    MH Apps Ltd
    Office 8 Unit 4.1
    Toll Clock Shopping Centre
    Lerwick
    Shetland ZE1 0DE

    Tel: 01595 70 80 90

    ©2018 MH Apps Ltd. All rights reserved.

    Subscribe to our newsletter (new)

    Quarterly with news, tips and advice for businesses.