Wednesday , October 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

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 …