Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server- Finding different object types in your database

Jul 30 2011 12:55AM by Fazal Vahora   

I just learned one new thing,"How to find different objects, which are used in database like tables,stored procedures,functions,views etc." check out following query.

select distinct type as Object_Type, type_desc  as Description from sys.objects
go

Note: sys.objects does not shows DDL triggers because they are not schema scoped. you can use sys.triggers for all triggers information.

Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Fazal Vahora
21 · 9% · 2808
6
 
5
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server- Finding different object types in your database" rated 5 out of 5 by 6 readers
SQL Server- Finding different object types in your database , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]