on 2010 Jul 06 1:55 AM
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.
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 EXECUTE IMMEDIATE
, it can be very difficult to determine accurately which objects are referenced from a procedure/trigger/UDF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.