SQL Server trigger when table is changed

Question

In my database, I have a specific request.

For some tables, let's call one Customer, I have a copy of it, let's call it Customer2 that needs to save some changes made on the records of the first one.

So, whenever I add a column to Customer, it needs to be added to the second one.

Since I'm doing it in a lot of tables, I cant simply duplicate the add column script.

I was thinking on using a DDL script for it, but cant seem to find a working solution.

Basically, what I need is to have a trigger, that whenever a table schema is changed, it would replicate the said change to the "copy" table.

Thanks in advance.

Gordon Linoff · Accepted Answer · 2016-04-22 11:21:18Z

1

What you are looking for is a DDL ("data definition language") trigger. You can specify such a trigger on alter table -- to capture when a new column is added.

The place to start is the documentation.

answered Apr 22, 2016 at 11:21

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server trigger when table is changed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related