Get List of Database Tables,Stored Procedures,View,Index,Functions and more

To find detail about procedures

 

select * from sys.procedures   

 

To find detail about view
 

select * from sys.views 
 

To find detail about tables

 

select * from sys.tables 

 

To find detail about triggers

 

select * from sys.triggers 
 

To find detail about indexes

 

select * from sys.indexes 

To find detail about databases

 

select * from sys.databases 

 

To find detail about servers

 

select * from sys.servers 

 

And more detail you can find using SYS .