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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.