Where are triggers stored?
触发器当前存储为 .TRG 文件,每个数据表一个文件.换句话说,每个 .TRG 文件属于某个表. 将来,我们打算改变这种做法,把触发器也保存在 .FRM 文件中,这个文件也定义了数据表结构.我们也打算把触发器作为数据库级的对象 – 而不是现在的数据表级,使之和SQL标准兼容. Triggers are currently stored in .TRG files, with one such file one per table. In other words, a trigger belongs to a table. In the future, we plan to change this so that trigger information will be included in the .FRM file that defines the structure of the table. We also plan to make triggers database-level objects — rather than table-level objects as they are now — to bring them into compliance with the SQL standard.
Triggers are currently stored in .TRG files, with one such file one per table. In other words, a trigger belongs to a table. In the future, we plan to change this so that trigger information will be included in the .FRM file that defines the structure of the table. We also plan to make triggers database-level objects — rather than table-level objects as they are now — to bring them into compliance with the SQL standard.
