Sunday, August 11, 2013

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.

No comments:

Post a Comment