查询mysql表结构,表注释,表主键,字段类型,字段长度等select distinct t.TABLE_SCHEMA, t.TABLE_NAME, t.TABLE_COMMENT, t1.COLUMN_NAME, t1.COLUMN_TYPE, t1.IS_NULLABLE, t1.COLUMN_DEFAULT, t1.COL...
SELECT CU.TABLE_NAME,LISTAGG(CU.COLUMN_NAME,',') within group(order by cu.TABLE_NAME) as COLUMN_NAME FROM USER_CONS_COLUMNS CU, USER_CONSTRAINTS AU WHERE CU.CONSTRAINT_NAME = AU.CONSTRAINT_NAME AN...
SELECT mm.table_name, group_concat(mm.column_name)FROM(SELECT table_name,COUNT(1)FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE constraint_name = 'PRIMARY' GROUP BY table_name HAVING COUNT(1) ...