Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: plelovsky on December 13, 2005, 03:18:56 am

Title: DDL generation
Post by: plelovsky on December 13, 2005, 03:18:56 am

Hi all,

1) how to include the 'ON DELETE CASCADE' clause of foreign key definition into generated DDL script for MS SQL Server?

2) how to exlude the note text of an operation with stereotype <<trigger>>, to not appear in generated script?

Thanks,
Pavel

Title: Re: DDL generation
Post by: hd on December 13, 2005, 01:59:25 pm

Quote

1) how to include the 'ON DELETE CASCADE' clause of foreign key definition into generated DDL script for MS SQL Server?

Open Operation Properties (select the table and press F10). Highlight the FK operation and select the Extended Properties... button.

Quote

2) how to exlude the note text of an operation with stereotype <<trigger>>, to not appear in generated script?

Currently the note field is the trigger body. In the future the trigger body will be entered in the Initial Code field of the Behaviour tab, and the note field will become the trigger comment.

Title: Re: DDL generation
Post by: wayne222 on December 13, 2005, 02:34:00 pm

hi

i seem to be having about the same trouble in editing the template. i would like the template to be able to display more information but i don't seem to be able to grasp the language. does any one know what languagge this templae is writern in so i can edit it. :)
the help on editing this template is very minimal any help at all would be great. i seem  to be stuck.

Title: Re: DDL generation
Post by: plelovsky on December 13, 2005, 09:55:19 pm

>> Open Operation Properties (select the table and press F10). Highlight the FK operation and select the Extended Properties... button.

.. there is a dialog there containing Index properties - Unique, Clustered, Ascending, Descending. What do I have to do there to solve my problem?

Pavel