WordPress at Your Fingertips
function is not described

maybe_drop_column() WP 1.0.0

Drops column from database table, if it exists.

No Hooks.

Return

true|false. True on success or if the column doesn't exist. False on failure.

Usage

maybe_drop_column( $table_name, $column_name, $drop_ddl );
$table_name(string) (required)
Database table name.
$column_name(string) (required)
Table column name.
$drop_ddl(string) (required)
SQL statement to drop column.

Notes

  • Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

Since 1.0.0 Introduced.

Code of maybe_drop_column() WP 5.8.2

function maybe_drop_column( $table_name, $column_name, $drop_ddl ) {
	global $wpdb;

	foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
		if ( $column === $column_name ) {

			// Found it, so try to drop it.
			$wpdb->query( $drop_ddl );

			// We cannot directly tell that whether this succeeded!
			foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
				if ( $column === $column_name ) {
					return false;
				}
			}
		}
	}

	// Else didn't find it.
	return true;
}