/// <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);