python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions