Remove a Plugin Manually

[SBarnes]

Hi Guys,

What SQL statements are needed to remove a plugin from the database under 7.1 I have a plugin that for some strange reason freezes Jiwa every time I try and delete it in plugin maintenance?

[Scott.Pearce]

I believe that all the SY_Plugin and associated tables have foreign keys defined with ON DELETE CASCADE, so a delete from SY_Plugin should delete all rows from associated tables for that plugin.

[Mike.Sheen]

The following do not have delete cascade on FK constraints to SY_Plugin, and will require additional delete statements to remove them:

SY_PluginEmbeddedReference
SY_PluginSchedule

[SBarnes]

Hi Guys

Firstly thanks for the replies, I think the problem may possibly have be caused by that the plugin was still enabled or that I had been shelling out to visual studio as the debugger that might be the issue some how.

Fortunately this plugin has no embedded references and isn't scheduled, it was picking up the custom fields which was my may concern so hopefully Scott's original answer will do the trick.