Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2014 @ 09:29:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sushant,

That's a bit of a general question.

Triggers allow you to specify that one or more actions should happen when a specified event happens.

For instance, when a row is inserted into 'table-1' (this is the event) then a row is inserted into 'table-2' (the action).

The action can include an insert, update or delete. It can happen before, after or instead of the event.

If you read the DDL syntax manual, that gives you the syntax and an idea of the variations allowed with triggers.

Does that help?

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>