Link to home
Start Free TrialLog in
Avatar of N_Sri
N_Sri

asked on

Finding all Views which use Table name and Column name of the same table



Hi,
 
Think that there is table ( Employee ) with Fields Name(Varchar), Active(Smallint),LastName(Varchar).
 
So this table is being used in many Views . Now I wanted to find all Views  which use table Employee and use Active(Smallint) in the Stored Procedure code...
 
 
 
Please help me to have such query.... I found some query by useing Text search... but it was not getting correct data.
 
 
 
litte urgent .. :(
ASKER CERTIFIED SOLUTION
Avatar of sventhan
sventhan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of N_Sri
N_Sri

ASKER

yeah, the result was not giving the exact data ...

We thought go mannually... :(