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