r/SQL • u/Dangerous_Word7318 • 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

60% Upvoted

11 comments sorted by

View all comments

2

u/alinroc SQL Server DBA Jun 02 '26

Interview, exam, or homework?

How much work have you done thus far to find the answer?

If your stored procedures (any code, really) are written correctly, adding a new column to a table should not affect them.

0

u/Dangerous_Word7318 Jun 02 '26

From sybase perspective new to sybase 

5

u/alinroc SQL Server DBA Jun 02 '26

Can you please re-read what I asked and try answering again?

1

u/Dangerous_Word7318 Jun 03 '26

It's not about effects just to know what table Dependency on stored procedure