DDL generation

[plelovsky]

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

[hd]

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.

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.

[wayne222]

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.

[plelovsky]

>> 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