File Details
| Downloads: |
140 |
File Size: |
2.6kB |
| Posted By: |
eralper |
Views: |
511 |
| Date Added: |
8 Jan 2008 |
|
Hi,
This is a DDL trigger (Data Definition Language trigger) which can be used in Microsoft SQL Server 2005 databases in order to keep two tables synchronized when one table structure is changed by adding a new column
The DDL trigger uses the EVENTDATA() information and select necessary data from sys.tables, sys.columns and sys.types
The DDL trigger can not be considered to be fully completed but I think it is a good sample to begin with
Eralper