Get all tables and stored procedures in sql server 2008

In this post we will discuss about how to get all tables and stored procedures in sql server 2008. Also check out my previous posts on:
To get all the tables in a database run below sql statement:
Use TestDB
SELECT NAME AS ‘List OF Tables’ FROM SYS.TABLES
The result will be shown as shown in the figure below:
To get all the stored procedure in a database run below sql statement:
Use TestDB
SELECT NAME AS ‘List OF Stored Procedures’ FROM SYS.PROCEDURES
The result will be shown as shown in the figure below:

You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply