Wednesday , October 17 2018
Home / DataBase / SQL SERVER / How to know object information in sql server

How to know object information in sql server

How to know object information in sql server:

Suppose we are working on a supporting project or Application Maintenance and we are new to that application and we don’t have the full knowledge on that database, in that situation some times we need to work on below things

  • we need to Identify from which stored procedure tables are modifying.
  • we need to Identify column usages in different views/Stored Procedure/Triggers etc
  • how many views are applied to the table?
  • how many triggers are applied to the table?
  • and many more

For above situation we have below query

in above syntax in the place give your name you can pass anything like column name,table name,view name,stored procedure name,trigger name etc.

it will retrieve all the occurrence of the passed name from entire database

for example here i want to know in which locations UserID column was used.

the above query returns below output it returns all the Sps,views etc which was used UserId column

Modules

Thanks for reading this article if you like this article please share with your Friends.

 

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …