public override string Generate(Expressions.DeleteForeignKeyExpression expression)
{
var constraintName = Quoter.QuoteConstraintName(expression.ForeignKey.Name, expression.ForeignKey.ForeignTableSchema);
return(string.Format(
"ALTER TABLE {0} DROP FOREIGN KEY {1}",
Quoter.QuoteTableName(expression.ForeignKey.ForeignTable, expression.ForeignKey.ForeignTableSchema),
constraintName));
}
public override string Generate(Expressions.DeleteForeignKeyExpression expression)
{
var constraintName = string.IsNullOrEmpty(expression.ForeignKey.ForeignTableSchema)
? Quoter.QuoteConstraintName(expression.ForeignKey.Name)
: Quoter.QuoteSchemaName(expression.ForeignKey.ForeignTableSchema) + "." + Quoter.QuoteConstraintName(expression.ForeignKey.Name);
return(string.Format(
"ALTER TABLE {0} DROP FOREIGN KEY {1}",
this.QuoteSchemaAndTable(expression.ForeignKey.ForeignTableSchema, expression.ForeignKey.ForeignTable),
constraintName));
}
public void Process(Expressions.DeleteForeignKeyExpression expression)
{
Process(Generator.Generate(expression));
}