oracle get table key

Hello geeks! In this post I have shared the details about “oracle get table key”. Okay, let’s move on to the post.

oracle get table key

SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name="TABLE_NAME"
AND cons.constraint_type="P"
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position;

Final Thoughts

I hope this tutorial helps you to know about “oracle get table key”. If you have any queries regarding this article please let us know via the comment section. Share this post with your friends & family via social networks.

Hi, I'm Ranjith a full-time Blogger, YouTuber, Affiliate Marketer, & founder of Coder Diksha. Here, I post about programming to help developers.

Share on:

Leave a Comment