Here I will explain simple SQL Query to get all table, procedure names in database or How to get list of all tables names in SQL Server Database or How to Get list of all procedures in SQL Server database.
In previous articles I explained Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server, Exception handling in SQL Server stored procedure, Reading xml file using 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 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
Get List of Stored Procedures in database
To get list of procedures in SQL Server we need to write the query like as shown below
SELECT * FROM SYS.PROCEDURES