达梦数据库查主键

最新推荐文章于 2024-06-27 09:51:22 发布

quant_Amy

最新推荐文章于 2024-06-27 09:51:22 发布

阅读量1k

点赞数 2

文章标签：数据库

本文链接：https://blog.csdn.net/Oo_Amy_oO/article/details/137065471

版权

SELECT t.table_name, c.column_name
FROM dba_cons_columns c
JOIN dba_constraints con ON c.constraint_name = con.constraint_name
JOIN (
    SELECT table_name, owner
    FROM dba_tables
    WHERE owner = 'CNDCDATA'
) t ON con.table_name = t.table_name AND con.owner = t.owner
WHERE con.constraint_type = 'P'
ORDER BY t.table_name, c.position;