# FW: CaseID:928346 - Toad-SS Object Explorer - User Define Tables Tab

**URL:** <https://forums.toadworld.com/t/fw-caseid-928346-toad-ss-object-explorer-user-define-tables-tab/14590>\
**Category:** Toad for SQL Server\
**Created:** [July 24, 2011, 12:50pm UTC](https://forums.toadworld.com/t/fw-caseid-928346-toad-ss-object-explorer-user-define-tables-tab/14590 "2011-07-24T12:50:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hfreeman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hfreeman/32/54_2.png) [@hfreeman](https://forums.toadworld.com/u/hfreeman)\
**Post date:** [July 24, 2011, 12:50pm UTC](https://forums.toadworld.com/t/fw-caseid-928346-toad-ss-object-explorer-user-define-tables-tab/14590/1 "2011-07-24T12:50:30Z")

</div>

To: Toad-ss user community à FYI !!!

Something to comment on, where appropriate !

Respectfully !!!

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

[hfreeman@msn.com](mailto:hfreeman@msn.com)

678-414-0090 my cell Primary

hank.freeman50 via Skype

Hiu, Valentine and Alex.

I am going to be using extended properties as you can see in the example below,  
where I have made and entry for the Primary Key of a new table CIS.BtuFactor.

What is going on here is as a DBA/Data Architect,

I am migrating DB2 mainframe databases, data table and columns names. Ax an  
example the DB2 table CIS\_BTU\_FACTOR à becomes SS-2008 CIS.BtuFactor for the  
tables and

KY\_BTU\_NO to PK\_BtuFactor as an example.

I am using this script to add a comment.

use [GCMA\_STAGE]

go

EXEC [sys] . [sp\_addextendedproperty]

@name = N'MS\_Description'

, @value = N' Orig: CIS BTU\_FACTOR.SS2008:PK\_KyBtuNo for CIS.BtuFactor records.  
'

, @level0type = N'SCHEMA' , @level0name = N'CIS' , @level1type = N'TABLE'

, @level1name = N'BtuFactor' , @level2type = N'COLUMN' , @level2name =  
N'PK\_BtuNo' ;

GO

WHAT IS Needed in Object Explorer is more functionality in displaying database,  
schema, table extended properties. Currently Object Explorer is doing a great  
job showing the column extended property as a comment, which should be labled  
MS\_Description. In the below example I am showing the prior DB2 name in the  
comment and this will aid those developing / migrating any applications from the  
DB2 system to the SQL Server system.

There4 : What I want to know is can the whole subject matter of what should be  
in Object Explorer be opened up a bit especially in regards to Extended  
Properties?

I personally like extended properties for the data element comment capabilities,  
but there is so much more that is done at the table and database level that if  
done right would be a real asset to Toad-SS users worldwide.

Please give this some serious thought and either incorporate what I am asking  
here into CaseID 928346 or please make a new CaseID, from this email

Respectfully !!!

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

[hfreeman@msn.com](mailto:hfreeman@msn.com)

678-414-0090 my cell Primary

hank.freeman50 via Skype

![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/cabfc34883d789b38492750ba5b372633206ba50.jpeg)

![image001.gif](https://global.discourse-cdn.com/quest/original/1X/c419a4884cb60937895dfef6b4b6862a4a679db6.gif)

 ![image006.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3d822771749dd3aa069581cf5efee7d9e58ad8e5.jpeg)  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/32454fc412d727b64a21b906492df75acd747dd5.jpeg)

---

<div class="post-metadata">

**Author:** ![Valentine](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/valentine/32/106_2.png) [@Valentine](https://forums.toadworld.com/u/Valentine)\
**Post date:** [July 27, 2011, 12:57pm UTC](https://forums.toadworld.com/t/fw-caseid-928346-toad-ss-object-explorer-user-define-tables-tab/14590/2 "2011-07-27T12:57:44Z")

</div>

I agree - extended properties deserve more attention. something to consider for upcoming release. Thanks for sharing!