Find all or any Table & Schema In SQL Server database(Using System Procedures)

Introduction:  

In this we will check how we can find Stored Procedure and Views in sql server database using query. We will use system stored procedure to find the Stored Procedure and Views .

Find Stored Procedure(s)

1.         To find all the stored procedures with details

                SELECT * FROM sys.procedures

Read More

Delete all views from sql server database with Query

Introduction: 

In this article i will explain how to delete all the views from Sql server database.

We can delete all views by executing single query. We don’t need to execute different query for each View.

Note: This command will delete all the views from your database.

Read More