 | |
#11
 
| |||
| |||
|
Re: List foreign keys -
07-29-2011
, 10:31 AM
|
Roy Hann wrote: Lee wrote: How can I get a list of a table's foreign keys, in Ingres 9.1? Rather annoyingly you can't get that information in a convenient form. In my eagerness to moan about how inconveniently encoded that information is, I forgot to point out the (possibly obvious) limitation that you will still only see the foreign keys that have been declared. There may well be any number of other foreign keys that are not identified as such; you just have to divine their existence or ask a savant. -- Roy UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012. * *NOTE THE CHANGED DATE* *Seewww.uk-iua.org.uk |
I shall give it a try on Monday.
Cheers
lee
#12
| |||
| |||
|
|
Roy Hann wrote: Lee wrote: How can I get a list of a table's foreign keys, in Ingres 9.1? Rather annoyingly you can't get that information in a convenient form. In my eagerness to moan about how inconveniently encoded that information is, I forgot to point out the (possibly obvious) limitation that you will still only see the foreign keys that have been declared. There may well be any number of other foreign keys that are not identified as such; ... |
Quote:
|
...you just have to divine their existence or ask a savant. -- Roy UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012. * *NOTE THE CHANGED DATE* *Seewww.uk-iua.org.uk |
#13
| |||
| |||
|
|
There may well be any number of other foreign keys that are not identified as such; ... Would you mind to elaborate a bit on this, Roy, please... |
declared as an SQL constraint or not. Programmers and users familiar
with a particular conceptual model (and therefore with its common keys)
will write joins just as well whether the foreign keys are declared or
not.
The query I suggested to identify foreign keys will report only the
foreign keys that have actually been declared. It can't report the
foreign keys that exist but haven't been declared.
As I said, if they're not declared you just have to "know" about them,
by divination or by asking someone else who knows. (Obviously word of
mouth is a very poor way to run a system....)
--
Roy
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
*NOTE THE CHANGED DATE* See www.uk-iua.org.uk
#14
| |||
| |||
|
|
How can I get a list of a table's foreign keys, in Ingres 9.1? The documentation for 9.1 is no longer on line, and my client apparently has none, either. Thanks in anticipation lee |
relationships, 1 per row. The row contains the referenced table ID,
the referencing table ID, the constraint ID and the mapping of foreign
key columns to corresponding primary/unique columns. I expect it'll
soon be available for native Ingres as well (10.0 or later). It is
true that getting the info prior to this is a total PITA.
Doug.
#15
| |||
| |||
|
#16
| |||
| |||
|
|
On Jul 29, 7:00*am, Lee <lee... (AT) gmail (DOT) com> wrote: FWIW, VectorWise introduces a new catalog that records all referential relationships, 1 per row. The row contains the referenced table ID, the referencing table ID, the constraint ID and the mapping of foreign key columns to corresponding primary/unique columns. I expect it'll soon be available for native Ingres as well (10.0 or later). |
Quote:
|
It is true that getting the info prior to this is a total PITA. |
Roy
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
*NOTE THE CHANGED DATE* See www.uk-iua.org.uk
#17
| |||
| |||
|
|
Roy Hann wrote: The best you can do AFAIK is: * select schema_name, table_name, text_segment * from iiconstraints * where constraint_type = 'R' ... *order by schema_name, table_name, constraint_name, text_sequence; |
Cheers
Lee
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.