Object DEpendancy

[scarletAni]

Is there any data dictionary table that will let us know
Procedure Name : what objects (views/ tables ) the procedure depends on ?

Is there a system table that will give this info ?
Need to know this urgently....
Thanx,
Ani

 

[tdatgod]

No.

That said there is command called.....

SHOW <query> ( it is like EXPLAIN <query> )

SHOW will break the query down into the list of views, and tables the query references.

I don't know if

show call mysp;

would work or not?

 

[scarletAni]

SHOW <SQL> works for a single SQL stmt only...

For Ex :
SHOW SELECT * FROM TableA;
SELECT * FROM TableB;

Gives only TableA defenition...
Thats too much information for me...
I just need to know the Table names that a procedure uses.

SHOW CALL ... Doesn't work !!

Thanx for that info anyways ...