Bookshelf Home | Contents | Index | PDF |
Siebel Server Sync Guide > Customizing Siebel Server Sync for Microsoft Exchange Server > Sample Delete TriggerThis topic contains the text of an existing delete trigger, SSSE_CONT_INFO_T1, and two drop-trigger statements that precede it. This trigger resides in the ssse_triggers_mssql.sql file, which is intended for Siebel implementations that use a Microsoft SQL Server database. The trigger operates when a record is deleted from table S_CONTACT_INFO. For more information about delete triggers, see About Creating Custom Delete Triggers and Creating Custom Delete Triggers. NOTE: In this sample text, -- Delete of S_CONTACT_INFO IF exists (select name from sysobjects where name = 'S_CONTACT_INFO_T1' drop trigger database_owner.S_CONTACT_INFO_T1 IF exists (select name from sysobjects where name = 'SSSE_CONT_INFO_T1' drop trigger database_owner.SSSE_CONT_INFO_T1 CREATE TRIGGER database_owner.SSSE_CONT_INFO_T1 insert into database_owner.S_SD_SYNC_INFO ( ROW_ID, CREATED, GETUTCDATE(), The following facts might be useful to you as you create new delete triggers based on existing triggers such as the preceding sample:
|
Siebel Server Sync Guide | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |