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%'
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|