Re: [GENERAL] Determining a table column by the view column.

2012-08-14 Thread John R Pierce
On 08/14/12 7:18 AM, Dmitriy Igrishin wrote: Hey all, Is there way to determine a table column referenced by a view column via SQL? I want to create an universal function to determine mandatoriness of some column of the view (i.e. check the not null constraint of underlying table column). no

Re: [GENERAL] Determining a table column by the view column.

2012-08-14 Thread raghu ram
On Tue, Aug 14, 2012 at 7:48 PM, Dmitriy Igrishin wrote: > Hey all, > > Is there way to determine a table column referenced by > a view column via SQL? > > I want to create an universal function to determine > mandatoriness of some column of the view (i.e. > check the not null constraint of under

[GENERAL] Determining a table column by the view column.

2012-08-14 Thread Dmitriy Igrishin
Hey all, Is there way to determine a table column referenced by a view column via SQL? I want to create an universal function to determine mandatoriness of some column of the view (i.e. check the not null constraint of underlying table column). Thanks. -- // Dmitriy.