Hi

I am using ASE 11 version

i have a table with 3 depends (stored procedures).

that is
usp_proc1
usp_proc2
having dependency on table Emp

How to drop and create dependencies on a table

pls advice

thanks & regards
Hari

Hi,
Dropping those stored procedures will remove the dependencies from emp table.
Recreating those stored procedures will create dependency if those procs refer to emp table.

thanks for the reply