public override string Translate(SqlCompilerContext context, SqlDropIndex node) { var indexName = context == null ? QuoteIdentifier(node.Index.DataTable.Schema.Name, node.Index.Name) : QuoteIdentifier(context.SqlNodeActualizer.Actualize(node.Index.DataTable.Schema), node.Index.Name); return("DROP INDEX " + indexName); }
/// <inheritdoc/> public override string Translate(SqlCompilerContext context, SqlDropIndex node) { var dropIndexTemplate = "DROP INDEX {0}.{1}"; if (context == null) { return(string.Format(dropIndexTemplate, node.Index.DataTable.Schema.Name, QuoteIdentifier(node.Index.DbName))); } return(string.Format(dropIndexTemplate, context.SqlNodeActualizer.Actualize(node.Index.DataTable.Schema), QuoteIdentifier(node.Index.DbName))); }
public void Test161() { var t = Catalog.Schemas["main"].Tables["customer"]; Index index = t.CreateIndex("MegaIndex196"); index.CreateIndexColumn(t.TableColumns[0]); SqlDropIndex drop = SqlDdl.Drop(index); Console.Write(Compile(drop)); }
/// <inheritdoc/> public override string Translate(SqlCompilerContext context, SqlDropIndex node) { if (!node.Index.IsFullText) { return("DROP INDEX " + QuoteIdentifier(node.Index.DbName)); } else { return("DROP FULLTEXT INDEX ON " + Translate(context, node.Index.DataTable)); } }
public override string Translate(SqlCompilerContext context, SqlDropIndex node) { return(string.Format("DROP INDEX {0} ON {1}", QuoteIdentifier(node.Index.Name), QuoteIdentifier(node.Index.DataTable.Name))); }
public virtual void Visit(SqlDropIndex node) { }
public override string Translate(SqlCompilerContext context, SqlDropIndex node) { return("DROP INDEX " + Translate(node.Index)); }
public void Visit(SqlDropIndex node) { }