oceanbase如何查找所有主键表
oracle租户
SELECT col.table_name, col.column_name
FROM user_constraints con, user_cons_columns col
WHERE con.constraint_name = col.constraint_name
AND con.constraint_type = ‘P’
AND col.table_name = upper(col.table_name);
mysql租户
SELECT t.table_name, k.column_name
FROM information_schema.TABLE_CONSTRAINTS t
JOIN information_schema.KEY_COLUMN_USAGE k
ON t.constraint_name = k.constraint_name
WHERE t.constraint_type = ‘PRIMARY KEY’
AND t.table_schema = DATABASE();
1 个赞
谢谢分享
谢谢分享学习了