Tuesday , June 19 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: