Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunil
Constraint Violating Yak Guru
282 Posts |
 Posted - 2007-09-14 : 01:01:24
|
| I have around 500 tables and many have triggers defined on them. How can I identify which tables have triggers defined on them and what kind of triggers (insert , update or delete). |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-14 : 12:51:37
|
| Check out sysobjects and look for type = 'TR'..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-14 : 12:52:27
|
| And you can tie it with syscomments to get to the unerlying tables, I think...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Identify tables with Triggers?