Re: Determining a table column by the view column.

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).


note that a view column can be the result of a function or operation,
perhaps on fields of several columns from several tables being joined in
the view.   how would your function cope with something like this?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast