To display the "Description Column" step in a SQL Server data table
- Turn off SMSS first
- Run (Ctrl+ R), enter regedit, and open the registry
- The editor is using 2019, version 18.10, and the path is as follows: Computer HKEY_Current_User Software Microsoft SQL Server Management Studio 18.0_IsoShell DataProject
- The above is to find the DataProject under your corresponding version number, (SQL Server 2008 R2 is 100, SQL Server 2012 is 11.0)
- Finally, we found SSVPropViewColumnsSQL70 and SSVPropViewColumnsSQL80
The values we see are: 1,2,6; Change it to: 1,2,6,17;, The columns represented by numbers are as follows:
(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) Collection (17) Description.