check column table dependencies sql server

How to check column table dependencies sql server?

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

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..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

How to check column table dependencies sql server? How to check column table dependencies sql server? Reviewed by Anil Singh on 3:09 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^