public override string Generate(Expressions.DeleteConstraintExpression expression)
{
var constraintName = Quoter.QuoteConstraintName(expression.Constraint.ConstraintName, expression.Constraint.SchemaName);
return(string.Format(
"ALTER TABLE {0} DROP CONSTRAINT {1}",
Quoter.QuoteTableName(expression.Constraint.TableName, expression.Constraint.SchemaName),
constraintName));
}
public override string Generate(Expressions.DeleteConstraintExpression expression)
{
var constraintName = string.IsNullOrEmpty(expression.Constraint.SchemaName)
? Quoter.QuoteConstraintName(expression.Constraint.ConstraintName)
: Quoter.QuoteSchemaName(expression.Constraint.SchemaName) + "." + Quoter.QuoteConstraintName(expression.Constraint.ConstraintName);
return(string.Format(
"ALTER TABLE {0} DROP CONSTRAINT {1}",
this.QuoteSchemaAndTable(expression.Constraint.SchemaName, expression.Constraint.TableName),
constraintName));
}
public void Process(Expressions.DeleteConstraintExpression expression)
{
Process(Generator.Generate(expression));
}
