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 .
Ebook Download
View all
Learn
View all