easy sql

kiwi · 14 Feb 2007 at 22:55

how do you find a list of the primary and foreign keys from tables? i know which are, but i need to show it. it's not something i've ever needed to do before.

JonB · 15 Feb 2007 at 01:24

Which SQL is it?

kiwi · 15 Feb 2007 at 01:27

JonB said:
Which SQL is it?

oracle sqlplus.

JonB · 15 Feb 2007 at 01:32

OK. Sowri no can do!

Is there not a tool which shows you all this? (Like management studio for MSSQL)

kiwi · 15 Feb 2007 at 01:43

i know which ones are primary keys but i have to identify them for an task. i need a query like "select field from all_tables where type='Pkey'"

Haircut · 15 Feb 2007 at 09:57

You need to look in all_constraints