/// <summary>
/// 生成删除主键约束的语句
/// </summary>
/// <param name="op">删除主键约束的对象</param>
protected override void Generate(RemovePKConstraint op)
{
using (var sql = this.Writer())
{
sql.Write("ALTER TABLE ");
sql.Write(this.Quote(op.TableName));
sql.Write(" DROP PRIMARY KEY;");
this.AddRun(sql);
}
}
protected override void Generate(RemovePKConstraint op)
{
using (var sql = this.Writer())
{
sql.Write(@"
ALTER TABLE ");
sql.Write(this.Quote(op.TableName));
sql.Write(@"
DROP CONSTRAINT ");
sql.Write(this.Quote(string.Format("PK_{0}_{1}",
this.Prepare(op.TableName), this.Prepare(op.ColumnName)
)));
this.AddRun(sql);
}
}
/// <summary>
/// 生成删除主键约束的语句
/// </summary>
/// <param name="op">删除主键约束的对象</param>
protected override void Generate(RemovePKConstraint op)
{
//SQLite 不支持
}
protected abstract void Generate(RemovePKConstraint op);
