Constraints

Database

Constraints

Is it possible to write a query to determine how 2 tables should be joined?
1 REPLY
Junior Contributor

Re: Constraints

Hi Rick,
if Foreign Keys are implemented, you might use the dbc.RI* views.
But most environments don't implement it :-(

Another way might be checking for columns with the same ColumnName.

Best way is probably looking a the huge Erwin printout on your wall :-)

Dieter