Which system tables or views can I query to find dependencies for a given object? I need a list of objects that both use or is used by an object.
asked 06 Jul '10, 00:55
For views/tables, you can use the sa_dependent_views system procedure.
It is much more problematic for other objects such as stored procedures. In SQL Anywhere, stored procedures are not "compiled" when created - they only need to be syntactically correct. Name resolution is done when the procedure is loaded, and with SQL Invoker semantics the objects that a procedure might reference will be different for each invoker. Also, since procedures/triggers/UDFs all permit
answered 06 Jul '10, 02:50