PowerDesigner16 of the generated footnotes, in SQL Server 2008, "Object name ' sysproperties ' invalid" error resolution

Mainly in modeling when we added some notes to the table, column, and Sql2005 after the system table sysproperties has been discarded and replaced by sys.extended_properties .

1. Modify the Table Tablecomment section

Menu database, Edit current DBMS Form General tab under Script, Objects, table–> tablecomment

Replace the following in the opening section:

[If Exists (select 1
From Sys.extended_properties
where major_id = object_id (' [%qualifier%]%table% ')
and minor_id = 0)

2. Modify the Column Columncomment section

Menu database, Edit current DBMS Form General tab under Script, Objects, column–> columncomment

Replace the following in the opening section:

[If Exists (select 1
From Sys.extended_properties
where major_id = object_id (' [%qualifier%]%table% ')
and minor_id <> 0 and name = ' ms_description ')