oracle--取出表字段，注释
遍历Oracle数据库获取表名和注释

select a.TABLE_NAME,TABLESPACE_NAME ,b.TABLE_TYPE,B.COMMENTSfrom user_tables   a,user_tab_comments   bWHERE A.TABLE_NAME=B.TABLE_NAMEorder by TABLE_NAME

遍历Oracle数据库获取视图名和注释

select a.view_NAME ,b.TABLE_TYPE,B.COMMENTSfrom user_views   a,user_tab_comments   bWHERE A.view_NAME=B.TABLE_NAMEorder by TABLE_NAME   

oracle里取出注释的语句

strsql = "select * from user_col_comments where comments is not null"

select * from user_tab_columns  where table_name = Upper('t_wp_s401');select   column_name    from   dba_tab_columns    where   owner=upper('xxx')    and   table_name='t_wp_s401';   select column_name,commentsfrom user_col_comments  where table_name = Upper('t_wp_s401') ;

sql server里取出注释的语句

SELECT Sysobjects.name AS TABLE_NAME,sys.extended_properties.[value] AS COLUMN_DESCRIPTION  FROM syscolumnsINNER JOIN systypes    ON syscolumns.xtype = systypes.xtype    LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id   LEFT OUTER JOIN sys.extended_properties ON   ( sys.extended_properties.minor_id = syscolumns.colid     AND sys.extended_properties.major_id = syscolumns.id)   LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id   WHERE syscolumns.id IN     (SELECT id FROM SYSOBJECTS WHERE xtype = 'U') AND (systypes.name <> 'sysname') and (Sysobjects.name='table10')    ORDER BY syscolumns.colid

vb.net 里取出注释的语句

test = "SELECT Sysobjects.name AS BLE_NAME,sys.extended_properties.[value] AS COLUMN_DESCRIPTION FROM syscolumns INNER JOIN systypes ON syscolumns.xtype = systypes.xtype LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id LEFT OUTER JOIN sys.extended_properties ON ( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id WHERE syscolumns.id IN  (SELECT id FROM SYSOBJECTS WHERE xtype = 'U') AND (systypes.name <> 'sysname') and (Sysobjects.name='table10') ORDER BY syscolumns.colid"