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