sql - 暴露Sql Jetbrains，删除Column

Question

如何删除 Exposed 中的列？

object PlayerKits : Table() { val player = varchar("uuid", 16) override val primaryKey = PrimaryKey(player) }

//添加列 - 工作

PlayerKits.integer("teste") SchemaUtils.createMissingTablesAndColumns(PlayerKits)

//删除 - 不工作

val col = Column<Int>(PlayerKits, "test", IntegerColumnType()) col.dropStatement()

标签： sqlkotlinkotlin-exposed

Answer 1

你可以试试：

transaction {
  col.dropStatement().forEeach { statement ->
     exec(statement)
  }
}