查询以查找主键和外键 [英] Query to find Primary and Foreign keys

问题描述

1.我有一张桌子。但我不知道如何在该表中找到主键列，忘记键列。 oracle中是否有任何程序或功能可以找到它？


谢谢，

Srinivasan r

Hi,

1. I have some table. But i do not know how to find primary key column, forign key column in that table. Is any procedure or function is available in oracle to find this?.

Thanks,
Srinivasan r

推荐答案

1.我有一张桌子。但我不知道如何在该表中找到主键列，忘记键列。 oracle中是否有任何程序或功能可以找到它？


谢谢，

Srinivasan r

Hi,

1. I have some table. But i do not know how to find primary key column, forign key column in that table. Is any procedure or function is available in oracle to find this?.

Thanks,
Srinivasan r

这是获取主键列表的查询：

Hi,

This is the query to get a list of primary keys:

展开 | 选择 | Wrap | 行号

1.我有一张桌子。但我不知道如何在该表中找到主键列，忘记键列。 oracle中是否有任何程序或功能可以找到它？


谢谢，

Srinivasan r

Hi,

1. I have some table. But i do not know how to find primary key column, forign key column in that table. Is any procedure or function is available in oracle to find this?.

Thanks,
Srinivasan r

以下查询将给出属于< owner_name>的表上指定的所有约束。架构。

Hi,
The following query will give all the constraints specified on a table belonging to <owner_name> schema.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

您好，


更正Chandu。你还应该拥有所有者的名字。

所以代码变成

Hi ,

To correct Chandu. you should also have the owner name.
So code becomes

展开 | 选择 | Wrap < span class =codeDivider> | 行号

这篇关于查询以查找主键和外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！