Get trigger's parent object id

Question

question

tabularyee asked Mar 2, '12

Get trigger's parent object id

Hi all, The following

SELECT object_name(parent_id) from sys.triggers where name = 'tr1'

Will return the parent table name from within the trigger, but I was wondering if it's possible to return the parent's object id? I thought object_id may do that but returns null. Any help would be much appreciated. Thanks

sql-server-2008 trigger

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-03-02T15:53:05Z

Mrs_Fatherjack answered Mar 2, '12

The Parent_obj column brings back the parent table's object id. To prove it run this: SELECT C.name, P.name, P.id, * FROM sysobjects C JOIN sysobjects P ON C.parent_obj = P.id WHERE C.name = 'enter trigger name here'

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Mar 02, 2012 at 03:59 PM

Be careful using those SQL 2000 system tables

1 ·

Mrs_Fatherjack commented · Mar 02, 2012 at 04:01 PM

That's because we are still on SQL 2000 :(

0 ·

Kev Riley ♦♦ commented · Mar 02, 2012 at 04:07 PM

Ouch! :(

0 ·

Answer 2 · 2012-03-02T15:54:49Z

KenJ answered Mar 2, '12

`parent_id` is the parent object's `object_id`. Check out `parent_id` in books-online - [ http://msdn.microsoft.com/en-us/library/ms188746.aspx][1] [1]: http://msdn.microsoft.com/en-us/library/ms188746.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question