Discussion :: Database Systems - Section 1 (Q.No.40)
|Shirisha said: (Feb 20, 2012)|
|The triggers are on a table , hence the ALTER TRIGGER seems the right answer. Please clarify|
|Vaibhav said: (Nov 10, 2013)|
|ALTER TABLE 'mytable'
ENABLE ALL TRIGGERS
Since it's for "all" triggers ALTER TABLE will be used.
I think ALTER TRIGGER is used while modifying a single trigger.
|Samee Marwat said: (Sep 12, 2015)|
|Dear student for enable/disable database triggers we use alter triggers and when we enable/disable all triggers on a table than we use the alter table command is used.|
|Sanjith said: (Jan 12, 2020)|
|Alter trigger is the correct answer.|
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.