weixin_44840242的博客

SELECT‘表名’ 表名,‘表中文名称’ 表中文名称,COLUMN_NAME 字段名称,COLUMN_TYPE 字段类型,COLUMN_DEFAULT 默认值,CHARACTER_MAXIMUM_LENGTH AS 最大长度,(CASEWHEN is_nullable = ‘NO’ THEN‘否’ELSE‘是’END) AS 是否可空,(CASEWHEN column_key = ‘PRI’ THEN‘是’ELSE‘否’END) AS 是否主键,COLUMN_

SELECTa.* ,CASEWHEN a.parent_id != ‘0’ THEN( SELECT name FROM sys_menu WHERE id = a.parent_id ) ELSE 0END AS ‘parentName’FROMsys_menu aORDER BYa.sort ASC