Wednesday , January 17 2018
Home / DataBase / SQL SERVER / Sql Server Important Queries

Sql Server Important Queries

Sql Server Important Queries:

1.View All Tables in a Particular Database:

For example if you want to know all table names which contains Sales

2.View All Triggers in a Particular Database:

3.View Any object definition:

in the place of Name we can give either table name or trigger name or Stored Procedure Name or View Name or Function Name etc.

4.View All Functions in a Particular Database:

5.View All Stored Procedures in a Particular Database:

6.View All Sequences in a Particular Database:

7.View all views in a Particular Database

8.View all Synonyms in a Particular Database

or
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: