I am going to share the code sample
for how to checkdependencies of table in Sql server. The example as give below.
Method 1 : using sp_depends to get table dependencies SQL Server
SP_DEPENDS 'DBO.USAGE'
Method 2 : using information_schema.routines to get table dependencies SQL Server
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES IS_RO
WHERE CHARINDEX('DBO.USAGE', IS_RO.ROUTINE_NAME) > 0
Method 3 : using SYSCOMMENTS
SELECT NAME FROM SYSCOMMENTS SYST
JOIN SYSOBJECTS SYSTOBJ ON SYST.ID = SYSTOBJ.ID
WHERE TEXT LIKE '%CALLTYPEID%'