Here I will explain simple SQL Query to get list of all stored procedures from SQL Server database or How to get list of all stored procedures in SQL Server Database or How to Get list of all tables in SQL Server database.
In previous articles I explained Pass table as parameter to stored procedure in SQL Server, Different types of joins in SQL Server, Difference between len & datalength functions in SQL Server, convert rows to columns in sql server without using pivot, Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server and many articles relating to SQL Server. Now I will explain how to get all tables and stored procedures in database using SQL Server.
Get List of Stored procedure names in database
To get list of procedures in SQL Server we need to write the query like as shown below
SELECT * FROM SYS.PROCEDURES
Get List of table names in database
To get list of tables in SQL Server we need to write the query like as shown below
SELECT * FROM SYS.TABLES