[GENERAL] Re: Extracting data from the view to retrieve the foreign key is not declared

Laurenz Thanks for your reply, it is going to help me. I use this query to get the dependencies of view with the objects in the db SELECT * FROM INFORMATION_SCHEMA.view_column_usage I now have to explain the attributes of the join tree, that is JOIN expressions e JOIN clauses. Thanks --

[GENERAL] Extracting data from the view to retrieve the foreign key is not declared

Given a view, I need to extract tables, the join columns (ON) . I need to do this analysis because of the view (agreements with the join condition and where) I can say that there is a foreign key Example: CREATE OR REPLACE VIEW x_customer AS SELECT a.asset_id, a.client_id FROM asset_d ad, asset