Trigger "delete

Trigger "delete_tag"

System:
Table:	taglinks
Events:	DELETE
Type:	After
Enabled:
When expression:	(no value)
Body:	BEGIN DELETE FROM tag WHERE idTag=old.idTag AND idTag NOT IN (SELECT DISTINCT idTag FROM taglinks); END

Definition:

CREATE TRIGGER delete_tag
  AFTER DELETE
  ON taglinks
BEGIN DELETE FROM tag WHERE idTag=old.idTag AND idTag NOT IN (SELECT DISTINCT idTag FROM taglinks);
		END;

Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20