SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Resources Download Files for Programmer and Administrators

Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

download files DDL Trigger for ALTER_TABLE to Synchronize Tables

File Details
Downloads: 3359 File Size: 2.6kB
Posted By: eralper Views: 14158
Date Added: 8 Jan 2008

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

No comments exist for this file.
Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems