Toad Generate DDL Script generates sp_addextendedproperty for every attribute for which a definition has been entered.

Toad Data Modeler
1

Is there any way to turn this off? Thanks.

2

Hello there,

You can enable/disable extended properties generation in DDL Script Generation dialog | Detail Settings.

ExtendedProperties1.png
ExtendedProperties1.png788×584 56.2 KB

Assuming that by attribute definition you mean attribute description/comments, uncheck Create Descriptions option to not generate the sp_addextendedproperty statements in DDL script.

Regards,

Lukas

3

Thanks very much.

Sent from my iPhone

On Jun 11, 2015, at 3:46 AM, Lukas Knapek bounce-LukasKnapek@toadworld.com wrote:

RE: Toad Generate DDL Script generates sp_addextendedproperty for every attribute for which a definition has been entered.

Reply by Lukas Knapek
Hello there,

You can enable/disable extended properties generation in DDL Script Generation dialog | Detail Settings.

Assuming that by definition you mean attribute description/comments, uncheck Create Descriptions option to not generate the sp_addextendedproperty statements in DDL script.

Regards,

Lukas

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Modeler - General notifications altogether.

Toad Data Modeler - Discussion Forum

Flag this post as spam/abuse.