# SQL 2005 extended Properties & Naming standards

**URL:** <https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912>\
**Category:** Toad Data Modeler\
**Created:** [March 6, 2009, 1:34pm UTC](https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912 "2009-03-06T13:34:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbusselman\_123636343](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@jbusselman\_123636343](https://forums.toadworld.com/u/jbusselman_123636343)\
**Post date:** [March 6, 2009, 1:34pm UTC](https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912/1 "2009-03-06T13:34:11Z")

</div>

Sorry if this is a duplicated post, but I didn’t see a forum search. I am having a problem generating the DDL statement for SQL Server 2005 to include the execution of the extended properties stored procedure to add the definitions of the data elements.

If i reverse engineer the DB and then generate the DDL it works, but not from a new model. I have the EXACT same problem with Erwin, which is why I’m evaluating TOAD. Am I missing a configuration somewhere?

Also, when converting from a logical to a physical model I want to apply some naming standards and couldn’t find if this is possible?

I am currently looking at the latest BETA version 3.4.1.5

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [March 9, 2009, 5:44am UTC](https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912/2 "2009-03-09T05:44:35Z")

</div>

1. 

> Also, when converting from a logical to a physical model I want to apply some naming standards and couldn't find if this is possible?

Unfortunately, it is not possible now.  
Nevertheless, we will deal with this issue. It's been registered under CR # 50 093.

We look forward to your reply.

Regards,

Vladka + TDM Team

Hello,

Let me reply to your questions.

1. 

> I am having a problem generating the DDL statement for SQL Server 2005 to include the execution of the extended properties stored procedure to add the definitions of the data elements.  
> If i reverse engineer the DB and then generate the DDL it works, but not from a new model. I have the EXACT same problem with Erwin, which is why I'm evaluating TOAD. Am I missing a configuration somewhere?

We are not definitely sure what you think, I'm sorry.  
Anyway, TDM does not load Extended Properties of objects, except for the extended property MS\_Description for some objects - this one is loaded.

Nevertheless, you write that it works for reversed model. Could you please send us the reversed model with any extended property? We'll check it out and will see what exactly you mean. (You can send it to: [modeling@quest.com](mailto:modeling@quest.com).)

---

<div class="post-metadata">

**Author:** ![jbusselman\_123636343](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@jbusselman\_123636343](https://forums.toadworld.com/u/jbusselman_123636343)\
**Post date:** [March 9, 2009, 12:18pm UTC](https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912/3 "2009-03-09T12:18:43Z")

</div>

Example Models sent to the e-mail address

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [March 10, 2009, 5:09am UTC](https://forums.toadworld.com/t/sql-2005-extended-properties-naming-standards/1912/4 "2009-03-10T05:09:42Z")

</div>

Hello Jeremy,

Thanks very much for your models. Now it is clear.- You meant the db procedures, not TDM procedures, and want to generate comments/descriptions in the SQL code.  
As I already wrote, extended property MS\_Description for some objects is loaded in TDM.

Please take the following steps in the model you created from scratch:

1. Open Entity Properties form | Description tab and write comments there.
2. In the Entity Properties form | General tab, assign a schema to the entity.  
(If you don’t have any schemas, simply click the button next to the Schemas box in the Entity Property form, create a schema and then select it for the entity).

Let me explain - To generate the table, column descriptions for SQL Server db in Toad Data Modeler, schema/owner has to be defined.

1. Press F9 to generate SQL script.

The problem will be solved then.

If you have more questions, please do not hesitate to write me.  
Thanks.

Regards,

Vladka + TDM Team