How to deactivate triggers?
Submitted by: AdministratorYou can use these SQL commands:
ALTER TRIGGER trigger_name INACTIVE;
ALTER TRIGGER trigger_name ACTIVE;
Most tools have options to activate and deactivate all triggers for a table. For example, in FlameRobin, open the properties screen for a table, click on Triggers at top and then Activate or Deactivate All Triggers options at the bottom of the page.
Submitted by: Administrator
ALTER TRIGGER trigger_name INACTIVE;
ALTER TRIGGER trigger_name ACTIVE;
Most tools have options to activate and deactivate all triggers for a table. For example, in FlameRobin, open the properties screen for a table, click on Triggers at top and then Activate or Deactivate All Triggers options at the bottom of the page.
Submitted by: Administrator
Read Online Firebird Job Interview Questions And Answers
Top Firebird Questions
| ☺ | How to detect the server version? |
| ☺ | How to write UDF s in Delphi? |
| ☺ | How do convert or display the date or time as string? |
| ☺ | How to drop all foreign keys in database? |
| ☺ | Is there some bulk load or other way to import a lot of data fast? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
