Get List of Tables in SqlServer

Introduction:

Here I will exaplain simple SQL Query to get all tables,procedure names in database or how to get list of all table names in sqlserver database or how to get list of all procedures in sql server database.

Query for retreving tables names in sqlserver :

USE Databasename

select * from sys.tables

Query for retreving stored procedures names in sqlserver :

USE Databasename

select * from sys.procedures