protected override void AppendTo(SqlStringBuilder builder)
{
builder.Append("CREATE ");
if (ReplaceIfExists)
builder.Append("OR REPLACE ");
builder.Append("TRIGGER ");
TriggerName.AppendTo(builder);
builder.Append(" ");
builder.AppendFormat("{0} {1} ", EventTime.ToString().ToUpperInvariant(), EventType.AsDebugString());
builder.Append("ON ");
TableName.AppendTo(builder);
if (Status != TriggerStatus.Unknown) {
if (Status == TriggerStatus.Disabled) {
builder.Append(" DISABLE");
} else if (Status == TriggerStatus.Enabled) {
builder.Append(" ENABLE");
}
}
builder.AppendLine();
builder.Indent();
Body.AppendTo(builder);
builder.DeIndent();
}