sys_plugins table

[Geoffrey Bishop]

1.  Under what circumstances does a brand new record go into this table?

2.  Why is there no Filter Navigator "Module" for this table?

3.  Can a record in this table ever have an Active value of false?

4.  This table seems to contain exactly the same records as the sys_package table, but only those with a class of "Sys Plugins".  Correct?

Thank you.

[Pavankumar_1 · Accepted solution]

Hi @Geoffrey Bishop 

1. If you install any plugin on the instance then new record will create and it will capture few details like plugin name, id and who installed and other details.

2. There are many tables which don't have module. Not sure.

3. Active will not be false because you can't deactivate plugin once it is active.

4. The major difference would be it will capture the package updates as well. if you update any plugin then records will be updated in sys_package  table.

Hope you it helps you.

Please Mark ✅ Correct/helpful if applicable, Thanks!! 

Regards

Pavankumar

[Geoffrey Bishop]

>The major difference would be it will capture the package updates as well. if you update any plugin then records will be updated in sys_package table.

Are you saying that the sys_plugins table does NOT capture any updates which are made to a Plugin?

Thank you.