出DB文档用SQL,DB2+MYSQL
MYSQL:
SELECT TABLE_NAME,TABLE_COMMENT FROM information_schema.TABLES WHERE table_schema='skysupport';
select ORDINAL_POSITION as '序号',COLUMN_NAME as '名称',DATA_TYPE as '数据类型',CHARACTER_MAXIMUM_LENGTH as '长度',
NUMERIC_SCALE as '小数位',IS_NULLABLE as...
原创
2020-07-27 13:38:23 ·
97 阅读 ·
0 评论