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:

In the last article i have explained Check Password case sensitive in Asp.net using Sql server during Login ,Sql Server Queries with Example and How to Excecute Store Procedure in Sql Server.

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.