How to get the Lists of number of store procedures and tables in Database in sql server - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

How to get the Lists of number of store procedures and tables in Database in sql server

Introduction: In this post I will explain we can get the Lists of number of store procedures and tables in Database in sql server.

Description:

Get list of All tables in Database:
use TEST_APPLICATION
select * from sys.tables
OR
select * from sys.tables
Here TEST_APPLICATION is the name of Database.
Get list of all Store procedure in Database:
use TEST_APPLICATION
select * from sys.procedures
OR
select * from sys.procedures
Here TEST_APPLICATION is the name of Database.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon