How I can receive the information about triggers on a table?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alexander_73
Posts: 52
Joined: Mon 24 Mar 2008 13:22

How I can receive the information about triggers on a table?

Post by Alexander_73 » Tue 16 Jun 2009 07:58

I have seen all of ObjectType property in TMSMetaData, but have not found possibility to learn about triggers of tables.
Top
Ludek
Posts: 301
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Tue 16 Jun 2009 08:26

select * from sys.triggers where parent_id = object_id()

8)
Top
Post Reply

Return to “SQL Server Data Access Components”