08 2022 档案

Mysql查询表名和字段明细，方便导出excel
摘要：SELECT COLUMN_NAME '列名', COLUMN_TYPE '数据类型', DATA_TYPE '字段类型', CHARACTER_MAXIMUM_LENGTH '长度', IS_NULLABLE '是否为空', COLUMN_DEFAULT '默认值', COLUMN_COMMENT 阅读全文
posted @ 2022-08-09 11:33 jyccc 阅读(137) 评论(0) 推荐(0) 编辑
oracle查询表字段和注释，方便导出excel
摘要：SELECT DISTINCT atc.table_name AS "表名" ,atcom.comments AS "表注释" ,atc.column_id AS "字段序号" ,atc.column_name AS "字段名" ,atc.data_type AS "字段类型" ,CASE WHEN 阅读全文
posted @ 2022-08-09 11:31 jyccc 阅读(290) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示