mysql
SELECT column_name ,COLUMN_COMMENT FROM information_schema.columns WHERE table_name=‘table1’
select a.attnum AS “序号”,
c.relname AS “表名”,
cast(obj_description(relfilenode,‘pg_class’) as varchar) AS “表名描述”,
a.attname AS “列名”,
concat_ws(’’,t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from ‘(.*)’)) as “字段类型”,
d.description AS “备注”
from pg_class c, pg_attribute a , pg_type t, pg_description d
where c.relname = ‘table1’
and a.attnum>0
and a.attrelid = c.oid
and a.atttypid = t.oid
and d.objoid=a.attrelid
and d.objsubid=a.attnum
ORDER BY c.relname DESC,a.attnum ASC
kingbasees表信息查看 mysql information_schema.columns对应查询
最新推荐文章于 2024-01-12 16:40:17 发布