mysql 表结构查询
查询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...
经验开发
2023-01-09 PM
oracle 查询所有表的主键
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...
经验开发
2022-04-01 AM
mysql 查询所有包含联合主键的表和联合主键
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) ...
基础运维
2019-05-28 PM