What does the lightning bolt icon next to a table name mean?

Matt

I recently upgraded SQL Prompt from 7.3 to 7.5 and I've noticed that some of the entries in the table picker have little lightning bolt icons next to them. I've tried to compare ones that do show the icons with ones that don't, but I can't spot any consistent differences that would explain it.

Here's what it looks like:




What does it mean?

[Deleted User]

Are there triggers on those tables?

Matt

Ding Ding! I think we have a winner.

That explanation checks out for every table I've looked at. And I just noticed that the SSMS icon for triggers is also a lightning bolt, so that seems like pretty good evidence that they're related.

Thanks!

James R

Hi Matt,

I can confirm that the lightning bolt icon means that there is a trigger on the table!

Thanks,
James