在POWERDESIGN中做的数据库设计倒入SQL中，能否保留住NAME栏的中文注释？

[qxm]

好象倒入到SQL中从数据字典中就找不到中文注释了，而且再反向工程回来NAME栏就也是和CODE栏一样的英文字段了。

[qxm]

得自己写代码才可以？用VBA吗？有没有什么具体的代码或者资料？
分不够可以再加！

[tjan]

不是VBA，就是 SQL 语句

在 database -> edit current DBMS ->general ->script -> objects ->table ->tablecomment 位置写table的

在 database -> edit current DBMS ->general ->script -> objects ->column ->columncomment 位置写column的

[qxm]

你说的这两个是在什么环境中？PD还是SQL SERVER？
我怎么找不到你所说的菜单项？你能具体写个SQL吗？
请恕我愚昧！
我的PD是6。5的

[tjan]

中文注释在 sysproperties.value 中

[tjan]

反向工程得自己写代码才可以。

[tjan]

不好意思，我以前用 ErWin ，PowerDesigner 我是从 8.0 开始用的，上面的内容，我在 8.0 和 9.5 环境下全部测试通过，并正在由系统设计人员使用。

[qxm]

那你写一个在8.0下的SQL给我看一下吗？
按照我们国家盗版的能力，我找个8.0或9.5 环境应该不成问题

[tjan]

表的属性
/****************************************/
/* table-SqlAttrQuery */
/****************************************/

{OWNER, TABLE, COMMENT}

select
sysusers.name,
sysobjects.name ,
convert(varchar(200),sysproperties.value)
from sysusers,
sysobjects,
sysproperties
where sysobjects.id = sysproperties.id
and sysobjects.xtype = 'U'
and sysproperties.smallid = 0
[ and sysusers.name='%OWNER%']
[ and sysobjects.name='%TABLE%']

/****************************************/
/* table-SqlChckQuery */
/****************************************/

{OWNER, TABLE, CONSTNAME, CONSTRAINT}

select
u.name,
t.name,
o.name,
m.text
from
dbo.sysobjects t,
dbo.sysusers u,
dbo.sysconstraints k,
dbo.syscomments m,
dbo.sysobjects o
where
o.xtype = 'C'
and u.uid = t.uid
and k.id = t.id
and o.id = k.constid
and k.constid = m.id
and k.colid=0
[ and t.name = '%TABLE%']
[ and u.name = '%OWNER%']

/****************************************/
/* table-TableComment */
/****************************************/

exec sp_updateextendedproperty N'MS_Description', N'%TLABL%', N'user', N'dbo', N'table', N'%TABLE%'
go

[tjan]

列的属性

/****************************************/
/* column-ColumnComment */
/****************************************/

exec sp_updateextendedproperty N'MS_Description', N'%COMMENT%', N'user', N'dbo', N'table', N'%TABLE%', N'column', N'%COLUMN%'
go

/****************************************/
/* column-SqlAttrQuery */
/****************************************/

{OWNER, TABLE, COLUMN, DOMAIN, COMPUTE, DEFAULT, COMMENT}

select
u.name,
t.name,
c.name,
d.name,
NULL,
'',''
from
sysusers u,
sysobjects t,
syscolumns c,
systypes d
where
c.id = t.id
and u.uid = t.uid
and c.xusertype<>c.xtype
and d.xusertype=c.xusertype
and c.iscomputed <> 1
and c.cdefault=0
[ and u.name='%OWNER%']
[ and t.name='%TABLE%']
[ and c.name = '%COLUMN%']
union select
u.name,
t.name,
c.name,
d.name,
NULL,
LTRIM(REVERSE(SUBSTRING(REVERSE(x.text), 1, PATINDEX('% sa %', REVERSE(x.text))))),''
from
sysusers u,
sysobjects t,
syscolumns c,
systypes d,
syscomments x
where
c.id = t.id
and u.uid = t.uid
and c.xusertype<>c.xtype
and d.xusertype = c.xusertype
and c.iscomputed <> 1
and c.cdefault <> 0
and x.id=d.tdefault
[ and u.name='%OWNER%']
[ and t.name='%TABLE%']
[ and c.name = '%COLUMN%']
union select
u.name,
t.name,
c.name,
NULL,
x.text,
'',''
from
sysusers u,
syscomments x,
sysobjects t,
syscolumns c
where
u.uid = t.uid and
x.id=t.id and
c.id=t.id and
c.colid=x.number and
c.iscomputed=1
[ and u.name='%OWNER%']
[ and t.name='%TABLE%']
[ and c.name = '%COLUMN%']
union
select
sysusers.name,
sysobjects.name ,
syscolumns.name ,'','','',
convert(varchar(200),sysproperties.value)
from
sysusers,
sysobjects,
syscolumns,
sysproperties
where
sysobjects.id = syscolumns.id
and sysusers.uid = sysobjects.uid
and sysobjects.xtype = 'U'
and syscolumns.id = sysproperties.id
and syscolumns.colid = sysproperties.smallid
[ and sysusers.name='%OWNER%']
[ and sysobjects.name='%TABLE%']
[ and syscolumns.name = '%COLUMN%']

/****************************************/
/* column-SqlChckQuery */
/****************************************/

{OWNER, TABLE, COLUMN, CONSTNAME, CONSTRAINT}

select
u.name,
t.name,
c.name,
o.name,
m.text
from
dbo.syscolumns c,
dbo.sysobjects t,
dbo.sysusers u,
dbo.sysconstraints k,
dbo.syscomments m,
dbo.sysobjects o
where
o.xtype = 'C'
and u.uid = t.uid
and c.id = t.id
and k.id = t.id
and o.id = k.constid
and k.colid = c.colid
and k.constid = m.id
[ and t.name = '%TABLE%']
[ and u.name = '%OWNER%']
[ and c.name = '%COLUMN%']