Thursday , February 21 2019
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

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


Print Friendly, PDF & Email

Give us your valuable feedback


About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :-, C#,, 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 …