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.
Published under: SQL Server Tips · · · ·