用PD生成的代码,sqlserver为什么不认呢?求大虾指教,PD的数据库设的是sqlserver2008if exists (select 1 from sysproperties where id = object_id('t_a_reject_report_transact_result') and type = 4) begin declare @CurrentUser sysname select @CurrentUser = user_name() execute sp_dropextendedproperty 'MS_Description', 'user', @CurrentUser, 'table', 't_a_reject_report_transact_result', 'column', 'transact_result' end
tools-->resources-->dbms-->sql server 2008打开DBMS属性窗口,在general选项卡中选择Microsoft SQL Server 2008-->script-->objects,可以修改Objects下的Table注释-表注释和Column注释-字段注释,
小F姐姐给的第二个方法好用,将sysproperties替换成(SELECT class AS id,Minor_id AS type,* from sys.extended_properties) _a 就可以啦无比感谢
from sysproperties
where id = object_id('t_a_reject_report_transact_result')
and type = 4)
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 't_a_reject_report_transact_result', 'column', 'transact_result'
end
tools-->resources-->dbms-->sql server 2008打开DBMS属性窗口,在general选项卡中选择Microsoft SQL Server 2008-->script-->objects,可以修改Objects下的Table注释-表注释和Column注释-字段注释,
就可以啦无比感谢