当前位置：首页 -> 基础 -> 数据库编程

PowerDesigner 16 sql server 2008生成备注报“对象名 'sysproperties' 无效”解决办法(二)

2014-11-24 09:55:33 · 作者: · 浏览: 1
标签: PowerDesigner sql server 2008 生成 备注 对象 ' sysproperties' 无效 解决 办法
_id = object_id('T_PRI_CarLimitPriceCache')
and minor_id = 0)
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 'T_PRI_CarLimitPriceCache'

end

select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'限价设定数据缓存',
'user', @CurrentUser, 'table', 'T_PRI_CarLimitPriceCache'
go

if exists (select 1
from sys.extended_properties
where major_id= object_id('T_PRI_CarLimitPriceCache')
and value = '店面编码')
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 'T_PRI_CarLimitPriceCache', 'column', 'MarketCode'

end
再执行的时候就不会报 [对象名 'sysproperties' 无效。]这个错误了。

现在把PowerDesigner 15里的TableComment 和 ColumnComment里的内容贴出来。
[plain]
-------------------------TableComment-----------------------------------
[%OWNER% [.O:[execute ][exec ]][sys.]sp_addextendedproperty [%R% [@%S%=][N]]'MS_Description',
[%R% [@%S%=][N]]%.q:COMMENT%,
[%R% [@%S%=][N]]'[.O:[user][schema]]', [%R% [@%S%=][N]]%.q:OWNER%, [%R% [@%S%=][N]]'table', [%R% [@%S%=][N]]%.q:TABLE%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]][sys.]sp_addextendedproperty [%R% [@%S%=][N]]'MS_Description',
[%R% [@%S%=][N]]%.q:COMMENT%,
[%R% [@%S%=][N]]'user', [%R% [@%S%=][N]]@CurrentUser, [%R% [@%S%=][N]]'table', [%R% [@%S%=][N]]%.q:TABLE%
]


-------------------------ColumnComment----------------------------------

[%OWNER% [.O:[execute ][exec ]]sp_addextendedproperty [%R% [N]]'MS_Description',
[%R% [N]]%.q:COMMENT%,
[%R% [N]]'user', [%R% [N]]%.q:OWNER%, [%R% [N]]'table', [%R% [N]]%.q:TABLE%, [%R% [N]]'column', [%R% [N]]%.q:COLUMN%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R% [N]]'MS_Description',
[%R% [N]]%.q:COMMENT%,
[%R% [N]]'user', [%R% [N]]@CurrentUser, [%R% [N]]'table', [%R% [N]]%.q:TABLE%, [%R% [N]]'column', [%R% [N]]%.q:COLUMN%
]

修改后的PowerDesigner 16里TableComment 和 ColumnComment里的内容贴出来。
[plain]
---------------------------------TableComment------------------------------
[if exists (select 1
from sys.extended_properties
where major_id = object_id('[%QUALIFIER%]%TABLE%')
and minor_id = 0)
begin
[%OWNER% [.O:[execute ][exec ]]sp_dropextendedproperty [%R% [N]]'MS_Description',
[%R% [N]]'user', [%R% [N]]%.q:OWNER%, [%R% [N]]'table', [%R% [N]]%.q:TABLE%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R% [N]]'MS_Description',
[%R% [N]]'user', [%R% [N]]@CurrentUser, [%R% [N]]'table', [%R% [N]]%.q:TABLE%
]
end


][%OWNER% [.O:[execute ][exec ]]sp_addextendedproperty [%R% [N]]'MS_Description',
[%R% [N]]%.q:COMMENT%,
[%R% [N]]'user', [%R% [N]]%.q:OWNER%, [%R% [N]]'table', [%R% [N]]%.q:TABLE%
:select @CurrentUser = user_name()
[.O:[exec