用php删除数据库中的列,php – 如何删除SilverStripe中过时的数据库列

最新推荐文章于 2022-06-03 17:45:00 发布

转载最新推荐文章于 2022-06-03 17:45:00 发布 · 120 阅读

文章标签：

#用php删除数据库中的列

这篇博客介绍了如何在SilverStripe应用开发中查找并可选地删除不再使用的数据库表和字段。由于这些遗留的列和表可能仍包含重要数据，SilverStripe框架不会自动删除它们。任务提供了SQL DROP和ALTER命令来显示这些过时的数据库元素，并提供了一种删除方式。但请注意，删除操作不可逆，所以在操作前务必备份。

Find and optionally delete disused tables and fields in a SilverStripe

database.

During development of a SilverStripe application it is common to delete a data object class or remove a field from a data object. This leaves obsolete columns and tables in your database. Because these columns or tables may contain data that you still want, the SilverStripe framework doesn’t delete those automatically. This task displays the obsolete columns and tables in the form of SQL DROP and ALTER commands. It also provides a way to delete them. If you do that, there is no undo, so always make a backup first.