Update-Trigger

Updates an existing trigger.

Syntax

Update-Trigger [-Name] <String> [-SchemaName <String>] [-Definition] <String> [<CommonParameters>]

Description

Updates an existing trigger.

Related Commands

Parameters

Name Type Description Required? Pipeline Input Default Value
Name String

The name of the trigger.

true false
SchemaName String

The schema of the trigger.

false false dbo
Definition String

The body of the trigger. Everything after and including the ON clause.

true false

EXAMPLE 1

Update-Trigger 'PrintMessage' 'ON rivet.Migrations for insert as print ''Migration applied!'''

Updates a trigger to prints a method when a row gets inserted into the rivet.Migrations table.