public override void WriteToStream(IndentStream stream) { stream.Write("CONSTRAINT "); ConstraintName.WriteToStream(stream); stream.Write($" "); KeyType.WriteToStream(stream); if (ClusterExpr != null) { stream.Write(" "); ClusterExpr.WriteToStream(stream); } if (WithExpr != null) { stream.Write(" "); WithExpr.WriteToStream(stream); } if (OnPrimary != null) { stream.Write(" "); OnPrimary.WriteToStream(stream); } }
public override void WriteToStream(IndentStream stream) { stream.Write("CREATE"); if (IsUnique) { stream.Write(" UNIQUE"); } stream.Write(" NONCLUSTERED INDEX "); IndexName.WriteToStream(stream); stream.Write(" ON "); TableName.WriteToStream(stream); stream.Write("("); ColumnList.WriteToStreamWithComma(stream); stream.Write(")"); if (WhereExpr != null) { stream.Write(" WHERE ("); WhereExpr.WriteToStream(stream); stream.Write(")"); } if (WithExpr != null) { stream.Write(" "); WithExpr.WriteToStream(stream); } if (OnPrimary != null) { stream.Write(" "); OnPrimary.WriteToStream(stream); } if (IsSemicolon) { stream.Write(" ;"); } }