Post
Ask Question

Get List of All Stored Procedures and Tables from Database in 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:

  1. USE SampleDB  
  2. SELECT * FROM SYS.PROCEDURES  
Get List of table names in database:
  1. USE SampleDB  
  2. SELECT * FROM SYS.TABLES