Oracle,Mysql,SqlServer2000 读取表备注语句

[b]Mysql读取字段备注信息[/b]：
select *
from Information_schema.columns
where table_Name='emptest';

select
concat(table_name, '.', column_name) as 'foreign key',
concat(referenced_table_name, '.', referenced_column_name) as 'references'
from
information_schema.key_column_usage
where
table_schema='$databasename' and
referenced_table_name is not null;

[b]Oracle读取字段备注信息[/b]

select A.column_name 字段名,B.comments 备注
from user_tab_columns A,user_col_comments B
where A.Table_Name = B.Table_Name and A.Column_Name = B.Column_Name and A.Table_Name='TEST'

[b]sql server读取备注信息[/b]
"SELECT o.name as tableName,c.name as columnName,p.value as Description FROM sysproperties p join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid where p.name='MS_Description' and o.name = 'yourtable'order by 1";