Querying Whether There is a Stored Procedure in SQL Server

Hello everyone,

In this article, I will try to give information about querying whether there is a Stored Procedure in SQL Server.

In SQL Server you may want to query if there is a Stored Procedure in some cases.

You can easily do this using the code below.

SELECT *
FROM sys.procedures
WHERE name LIKE '%Buraya Yazılacak%'; -- aranılan prosedür isme göre % % alanları içerisine yazılacak

When you run the above code, you will see a result like the one below.

As you can see, we are questioning whether there is a Stored Procedure.

Good luck to everyone in business and life.