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); }