/// <summary> /// Get the SQL string to drop this Constraint in the database. /// </summary> /// <param name="dialect">The <see cref="Dialect.Dialect"/> to use for SQL rules.</param> /// <param name="defaultSchema"></param> /// <param name="defaultCatalog"></param> /// <returns> /// A string that contains the SQL to drop this Constraint. /// </returns> public override string SqlDropString(Dialect.Dialect dialect, string defaultCatalog, string defaultSchema) { string ifExists = dialect.GetIfExistsDropConstraint(Table, Name); string drop = string.Format("alter table {0} {1}", Table.GetQualifiedName(dialect, defaultCatalog, defaultSchema), dialect.GetDropForeignKeyConstraintString(Name)); string end = dialect.GetIfExistsDropConstraintEnd(Table, Name); return(ifExists + System.Environment.NewLine + drop + System.Environment.NewLine + end); }
/// <summary> /// Get the SQL string to drop this Constraint in the database. /// </summary> /// <param name="dialect">The <see cref="Dialect.Dialect"/> to use for SQL rules.</param> /// <param name="defaultSchema"></param> /// <param name="defaultCatalog"></param> /// <returns> /// A string that contains the SQL to drop this Constraint. /// </returns> public override string SqlDropString(Dialect.Dialect dialect, string defaultCatalog, string defaultSchema) { var catalog = Table.GetQuotedCatalog(dialect, defaultCatalog); var schema = Table.GetQuotedSchema(dialect, defaultSchema); var quotedName = Table.GetQuotedName(dialect); return(new StringBuilder() .AppendLine(dialect.GetIfExistsDropConstraint(catalog, schema, quotedName, Name)) .AppendFormat("alter table ") .Append(Table.GetQualifiedName(dialect, defaultCatalog, defaultSchema)) .Append(" ") .AppendLine(dialect.GetDropForeignKeyConstraintString(Name)) .Append(dialect.GetIfExistsDropConstraintEnd(catalog, schema, quotedName, Name)) .ToString()); }