public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteEnum(tableCheck, WhitespacePadding.SpaceAfter);
WriteCheckOperation(writer);
writer.WriteKeyword(" CONSTRAINT ");
if (constraintName != null) {
writer.WriteScript(constraintName, WhitespacePadding.None);
} else {
writer.WriteKeyword("ALL");
}
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword(UniqueKindName);
writer.Write(' ');
writer.WriteEnum(clustered, WhitespacePadding.SpaceAfter);
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(indexColumns, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
writer.WriteScript(indexOptionGroup, WhitespacePadding.SpaceBefore);
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("CREATE ");
if (unique) {
writer.WriteKeyword("UNIQUE ");
}
writer.WriteEnum(clustered, WhitespacePadding.SpaceAfter);
writer.WriteKeyword("INDEX ");
writer.WriteScript(IndexName, WhitespacePadding.None);
writer.WriteKeyword(" ON ");
writer.WriteScript(TableName, WhitespacePadding.None);
writer.Write(" (");
using (writer.Indent()) {
writer.WriteScriptSequence(indexColumns, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
if (includeColumnNames.Count > 0) {
writer.WriteKeyword(" INCLUDE ");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(includeColumnNames, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
}
WhitespacePadding optionsPadding = WhitespacePadding.SpaceBefore;
if ((filter != null) && writer.IsAtLeast(DatabaseEngine.SqlServer2008)) {
writer.WriteLine();
writer.WriteKeyword("WHERE ");
using (writer.Indent()) {
writer.WriteScript(filter, WhitespacePadding.None, null, null);
}
optionsPadding = WhitespacePadding.NewlineBefore;
}
writer.WriteScript(IndexOptions, optionsPadding);
}
private void WriteToInternal(SqlWriter writer, string command) {
WriteCommentsTo(writer);
writer.WriteKeyword(command);
writer.WriteKeyword(" TRIGGER ");
writer.WriteScript(triggerName, WhitespacePadding.None);
writer.WriteKeyword(" ON ");
writer.WriteScript(tableName, WhitespacePadding.SpaceAfter);
writer.WriteScript(type, WhitespacePadding.SpaceAfter);
string prefix = null;
foreach (DmlOperation operation in triggerOperations) {
writer.Write(prefix);
writer.WriteEnum(operation, WhitespacePadding.None);
prefix = ", ";
}
writer.WriteScript(replication, WhitespacePadding.SpaceBefore);
writer.WriteKeyword(" AS");
using (writer.Indent()) {
writer.WriteScript(statement, WhitespacePadding.NewlineBefore);
}
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteEnum(ddlOperation, WhitespacePadding.None);
writer.Write(' ');
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(columnName, WhitespacePadding.None);
writer.WriteEnum(order, WhitespacePadding.SpaceBefore);
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.Write(UniqueKindName);
writer.WriteEnum(clustered, WhitespacePadding.SpaceBefore);
writer.WriteScript(indexOptionGroup, WhitespacePadding.SpaceBefore);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("ON ");
writer.WriteEnum(operation, WhitespacePadding.None);
writer.Write(' ');
writer.WriteKeyword(ActionString);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(expression, WhitespacePadding.None);
writer.WriteEnum(oderType, WhitespacePadding.SpaceBefore);
}
