SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Forums for Programmer, Administrators and Users

Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

How to list SQL triggers created on Database Views on SQL Server

Last post 10-09-2018, 3:11 AM by eralper. 0 replies.
Sort Posts:
  •  10-09-2018, 3:11 AM 52138

    How to list SQL triggers created on Database Views on SQL Server

    Recently, I had required to prepare the list of triggers created on views on a certain database.
    Database developers can query the system view sys.triggers for triggers created on that database.
    If you check the parent object (table or view) properties using ObjectProperty() function with 'IsView' argument as input, you can have your SQL query for the list of all triggers created on database views

    select
     name trigger_name, object_name(parent_id) view_name
    from sys.triggers
    where objectproperty(parent_id,'IsView') = 1


View as RSS news feed in XML
Copyright © 2004 - 2019 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems