db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: SQL Authorization for dblook: Progress Update
Date Mon, 01 Jun 2009 05:38:23 GMT
Hiranya Jayathilaka <hiranya911@gmail.com> writes:

>> A table can depend on a function. This is because the table could have a
>> generated column whose generation clause invokes a user-defined function.
>
>
> Do we capture these dependencies in the system tables? Can I get the
> information regarding these dependencies by referring the SYSDEPENDS table
> or some other system table?

I should think so.. Can you answer this one, Rick? Also, a CHECK
constraint may depend on functions, and this is recorded in
SYSDEPENDS.

Dag



Mime
View raw message