Introduction:
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.
Description:
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.