Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2012-05-10 : 11:07:12
|
| Hi Everyone -I use the Description property quite a lot, and I would like to have that particular property show up on the screen. The screen I am referring to is the Create / Edit table, where there are three columns shown (Column Name, Data Type, Allow Nulls)... I simply want to add the Description property next to the allow nulls column.Can this be accomplished?thank youtony |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-10 : 12:17:47
|
| hmm? You want to modify the wizard itself? Should be question for SQL Server product development group I reckon------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2012-05-10 : 15:14:53
|
| Here are the steps to add a property to the table designer in SQL Server Management Studio. The steps involve altering the values in registry settings.NOTE: Please be careful while altering registry keys. •Type regedit in the Windows Start --> Run command to open the Registry Editor. •Navigate to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\DataProject •You might need to change the SQL Server version accordingly. I am using SQL Server 2008 R2 Express and hence the version 100. •Under the above mentioned registry path, look for the keys SSVPropViewColumnsSQL70 and SSVPropViewColumnsSQL80. •By default, these registry keys will have the values 1,2,6;. Section Property sequence mentioned below shows the number associated with each property. For my requirement to add Description column to the table designer, I had to change the registry key values to 1,2,6,17; •Right-click on the key and select Modify option. Change the value from 1,2,6; to 1,2,6,17;. This has to be done on both the keys SSVPropViewColumnsSQL70 and SSVPropViewColumnsSQL80 •NOTE: Remember to restart SSMS between each registry change. Property sequence: 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 Hope this helps someone. |
|
|
|
|
|
|
|
|
Customize the properties column in designer