Вообще как не странно, но в sqlserver2005.fet есть следующее
Create Entity
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
/*Generate UDP's and Comments as Extended Properties*/
[
FE::Option( "CreateTable" )
ShouldGenerate
/* Set the variables required by the "Clause: Specify Extended Properties". */
Set( "var_Operation", "sp_addextendedproperty" )
Set( "var_RemoveVariables", "false" )
Set( "var_Comment", "Comment" )
Set( "var_Level0Type", "SCHEMA" )
[
PushReference( "Schema_Ref" )
Set( "var_Level0Name", Property( "Name" ) )
Pop
]
Set( "var_Level1Type", "TABLE" )
Set( "var_Level1Name", Property( "Physical_Name" ) )
/* Generate Table comments and UDPs */
Execute( "Clause: Specify Extended Properties" )
/* Generate column comments and UDPs */
Set( "var_Level2Type", "COLUMN" )
ForEachReference( "Physical_Columns_Order_Ref" )
{
Set( "var_ExtendedPropertyValue", Property( "Comment" ) )
Set( "var_Level2Name", Property( "Physical_Name" ) )
Execute( "Clause: Specify Extended Properties" )
}
/* Generate key group comments and UDPs */
Set( "var_Level2Type", "INDEX" )
ForEachOwnee( "Key_Group" )
{
Set( "var_ExtendedPropertyValue", Property( "Comment" ) )
Set( "var_Level2Name", Property( "Physical_Name" ) )
Execute( "Clause: Specify Extended Properties" )
}
/* Remove the variables. */
[ Remove( "var_Operation" ) ]
[ Remove( "var_Comment" ) ]
[ Remove( "var_RemoveVariables" ) ]
[ Remove( "var_ExtendedPropertyName" ) ]
[ Remove( "var_ExtendedPropertyValue" ) ]
[ Remove( "var_Level0Type" ) ]
[ Remove( "var_Level0Name" ) ]
[ Remove( "var_Level1Type" ) ]
[ Remove( "var_Level1Name" ) ]
[ Remove( "var_Level2Type" ) ]
[ Remove( "var_Level2Name" ) ]
]
и далее
Clause: Specify Extended Property
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
[
OnceForObject( "Comment")
/* Set the local flag to false. */
Set( "var_bProceed", "false" )
/* Generate comments */
[
FE::Option( "Comments" )
Switch( Value( "var_Operation" ) )
{
Choose( "sp_addextendedproperty" )
{
Set( "var_bProceed", "true" )
}
Choose( "sp_updateextendedproperty" )
{
[
IsPropertyModified( Value( "var_Comment" ) )
Set( "var_bProceed", "true" )
]
}
}
Equal( Value( "var_bProceed" ), "true" )
Set( "var_ExtendedPropertyName", "MS_Description" )
Set( "var_ExtendedPropertyValue", Property( Value( "var_Comment" ) ) )
"EXEC "
Value( "var_Operation" )
< Execute( "Clause: Specify Extended Property" ) >
]
/* Reset the local flag */
Set( "var_bProceed", "false" )
/* Generate the UDPs. */
[
FE::Option( "OtherOptionsUserDefinedProperties" )
Set( "var_UserDefined", Property( "User Defined" ) )
ForEachProperty( "UserDefined" )
{
Switch( Value( "var_Operation" ) )
{
Choose( "sp_addextendedproperty" )
{
Set( "var_bProceed", "true" )
}
Choose( "sp_updateextendedproperty" )
{
[
IsPropertyModified( Value( "var_UserDefined" ) )
Set( "var_bProceed", "true" )
]
}
}
Equal( Value( "var_bProceed" ), "true" )
Set( "var_ExtendedPropertyName", ForEachProperty.Type )
Set( "var_ExtendedPropertyValue", ForEachProperty.Value )
"EXEC "
Value( "var_Operation" )
< Execute( "Clause: Specify Extended Property" ) >
}
]
/* Remove the variables */
Remove( "var_bProceed" )
[
Equal( Value( "var_RemoveVariables" ), "true" )
[ Remove( "var_Comment" ) ]
[ Remove( "var_RemoveVariables" ) ]
[ Remove( "var_ExtendedPropertyName" ) ]
[ Remove( "var_ExtendedPropertyValue" ) ]
[ Remove( "var_Level0Type" ) ]
[ Remove( "var_Level0Name" ) ]
[ Remove( "var_Level1Type" ) ]
[ Remove( "var_Level1Name" ) ]
[ Remove( "var_Level2Type" ) ]
[ Remove( "var_Level2Name" ) ]
]
]
Так же в Forward Engineer Schema Generation в Other Options выставлено "User Defined Properties"
И все равно при генерации скрипта создается только одно extended property - "MS_Description", т.е. комментарий к имени сущности/столбца. :-\
