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

Here, you will see how to 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 .