DDL Naming Templates - extensions

[Paolo F Cantoni]

The DDL Naming templates (Tools|Options...Source Code Engineering|Code Editors|DDL Name Templates...) are useful.  However, their utility would be improved if there was a list of the variables one could use in creating the name.  

For example, we have long table and column names, but we use standardized abbreviations for these long names.  These could be placed in the Alias property and thereby be available for inclusion in the templates.  So could we also have tablealias, columnalias, foreigntablealias and primarytablealias please?

TIA,
Paolo

[size=0]©2007 Paolo Cantoni, -Semantica-[/size]

[Paolo F Cantoni]

As per: [size=13]IDEA: Better FK constraint naming rule[/size], can we also have foreigncolumnsetname, foreigncolumnsetalias, primarycolumnsetname and primarycolumnsetalias please?

In all cases, if there is more than one column in the ColumnSet, then use the first unique one, else use the first one.  If there is a name clash with an existing name then use another concatenated column name.

Paolo

[size=0]©2007 Paolo Cantoni, -Semantica-[/size]