How to get the Lists of number of store procedures and tables in Database in sql server | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF 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.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget