获取表结构中注释信息的语句
获取表结构中注释信息的语句
获取表注释：
SELECT table_name &表名,TABLE_COMMENT 表注释 FROM INFORMATION_SCHEMA.TABLES &WHERE table_schema = 'yikang' ##名
AND table_name LIKE 'food'##表名
获取字段注释： & &
SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'food'##表名
AND table_schema = 'yikang'##数据库名
AND column_name = 'name'##字段名
作者 黑豆白
(window.slotbydup=window.slotbydup || []).push({
id: '2467140',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467141',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467142',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467143',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467148',
container: s,
size: '1000,90',
display: 'inlay-fix'10664人阅读
MySQL（15）
库的 TABLES 表中&字段里
或者使用：show table status
最后一列：Comment 就是表注释
获取一个表里面的字段注释的sql：
show full fields from table
最后一列：Comment 就是字段注释
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：251739次
积分：3207
积分：3207
排名：第7993名
原创：63篇
转载：79篇
评论：32条
(2)(2)(1)(1)(2)(1)(1)(2)(1)(1)(1)(1)(3)(3)(1)(4)(4)(1)(1)(1)(1)(1)(2)(3)(1)(1)(2)(4)(3)(6)(5)(7)(2)(6)(11)(2)(5)(8)(10)(8)(3)(2)(7)(9)(3)获取数据表的字段名和字段注释
获取数据表的字段名和字段注释
1、oracle： & &
& & & & & & & & SELECT t1.COLUMN_NAME,
& & & & & & & & &MENTS
& & & & & & & & &FROM user_tab_columns t1,
& & & & & & & & &user_col_comments t2
& & & & & & & & &WHERE t1.TABLE_NAME='表名'
& & & & & & & & &AND t1.TABLE_NAME &=t2.TABLE_NAME
& & & & & & & & AND t1.COLUMN_NAME =t2.COLUMN_NAME;
2、通过ResultSetMetaData中获取字段名，但是不能获取字段注释
(window.slotbydup=window.slotbydup || []).push({
id: '2467140',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467141',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467142',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467143',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467148',
container: s,
size: '1000,90',
display: 'inlay-fix'}