Friday, May 8, 2009

Query to Retrieve all the Tables,Views,Stored Procedure and Functions from Sql Server

Select * from sys.all_objects
Select * from information_schema.columns
Select * from information_schema.tables

1 comment:

electronic signature software said...

Great read! I love it, I love it so much that the greedy gnome in me wants more.