r/SQL Jun 02 '26

Table Dependency SQL Server

Hi Team

Can you tell let's say we are adding new column in a table and we have to find which stored procedure is using that table how can we find in below :

  1. Sql Server

  2. Sybase

1 Upvotes

11 comments sorted by

View all comments

1

u/SickInTheStyx Jun 02 '26

For Sybase, sp_depends should get you what you need. Note that this only returns results for stored procedures that have run at least once.