Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82

    Unanswered: How to list of triggers on the table

    Hello,

    is there any possibility how to list triggers... ?

    Something similar as sp_helptrigger on MSSQL?

    http://doc.ddart.net/mssql/sql70/sp_help_66.htm

    David

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Try this
    Code:
    select "table name" = name
    ,"insert trigger" = object_name(instrig)
    ,"update trigger" = object_name(updtrig)
    ,"delete trigger" = object_name(deltrig)
    from   sysobjects
    where  type = "U"
    --and    name = @table_name
    order by name

  3. #3
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82
    Thanks for hint... But for this I need rights for sysobjects...

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    exec sp_depends 'table name'

    will show the trigger on the table.

    Alternatively, you can take the above code supplied in a previous thread and create a sp_helptrigger in sybprocs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •