Post reply

Regarding triggers on a table

  • November 12, 2007 at 10:34 pm

    #200432

    Hi all,

    I have a basic question. How can i find what are all the triggers on a specific table?

    Thanks n good day

    - sri

  • November 13, 2007 at 12:28 am

    #750489

    Look up sp_helptrigger in Books Online

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2007 at 5:38 am

    #750608

    Use the below command to find out the DML and DDL triggers available in a database.

    Run the command in a database

    [font="Courier New"]select name as 'Trigger Name',case parent_class when 1 then 'DML' when 0 then 'DDL' end 'DML or DDL trigger',object_name(parent_id) 'Table Name',type_desc 'Trigger Type' from sys.triggers[/font]

    Regards..Vidhya Sagar
    SQL-Articles

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply