Topic: 字段注释

  Print this page
1.字段注释 Copy to clipboard
Posted by: daywalker
Posted on: 2003-09-15 16:43

请教一个问题，有没有使用jdbc读取数据表中子段注释的办法？
2.Re:字段注释 [Re: daywalker] Copy to clipboard
Posted by: jeremy
Posted on: 2003-09-18 12:54

SELECT ucc.comments
FROM User_Col_Comments ucc
WHERE ucc.table_name='tablename'
AND ucc.column_name='columnname'
3.Re:字段注释 [Re: daywalker] Copy to clipboard
Posted by: daywalker
Posted on: 2003-09-18 16:10

我按你写的试了一下,提示ucc:表或视图不存在
然后试着写成
select comments from user_col_comments
where table_name='tablename' and column_name='colname' 可以运行
不知道ucc是指什么?
4.Re:字段注释 [Re: daywalker] Copy to clipboard
Posted by: jeremy
Posted on: 2003-09-18 16:58

这么奇怪！ ucc只是别名而已
5.Re:字段注释 [Re: daywalker] Copy to clipboard
Posted by: daywalker
Posted on: 2003-09-20 09:34

连日加班，有点迷糊了 Smile
谢谢你的 帮助

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923