Get sql server objects list

In PL/SQL we can user ‘User_Objects’ to retrieve list of al the objects.

In SQL Server this can be achieved by using ‘sys.Objects’. This provides a high level view of all the objects which can be used for retrieving various type of information.

Example

SELECT * FROM  sys.objects

 

image

 

Below queries can be used to extract a specific type of object details.
 
 

SELECT * FROM  sys.Procedures

 

 SELECT * FROM  sys.tables

 

 SELECT * FROM  sys.views

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s