日志表架构更改 [英] Log table Schema changes

问题描述

每当进行模式更改时，是否有任何方法可以记录在表的模式中所做的更改？

Is there any way to log the changes made in Schema of a Table whenever I do the schema changes?

我在这里阅读有关 DDL触发器 。但这并不能说明在表的架构中所做的特定更改。

I was reading an article here about DDL Triggers. But it does not tell about the specific changes made in schema of a table.

推荐答案

对于此问题，我可能会使用事件通知。尽管我认为DDL触发器确实可以说明对表所做的特定更改，但只需定义触发器即可：

For this issue i would probably use Event Notifications. Although DDL trigger's in my opinion do tell about specific changes made to table, just trigger definition:

Create Trigger tr_DDLNotikums
    On DataBase
For **DDL_DATABASE_LEVEL_EVENTS** 

这篇关于日志表架构更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！