How to Rename Column Using Migration in Laravel

To rename a column in Laravel migration, use the renameColumn method inside the Schema::table function. Ensure you have installed the doctrine/dbal package as Laravel requires it for renaming columns.

Syntax

Use the Schema::table method to modify an existing table. Inside the callback, call $table->renameColumn('old_name', 'new_name'); to rename the column.

Make sure the doctrine/dbal package is installed because Laravel uses it to handle column renaming.

php

Schema::table('table_name', function (Blueprint $table) {
    $table->renameColumn('old_column', 'new_column');
});

Example

This example renames the column username to user_name in the users table.

First, install the required package with composer require doctrine/dbal. Then create a migration and add the rename code.

php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class RenameUsernameColumnInUsersTable extends Migration
{
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->renameColumn('username', 'user_name');
        });
    }

    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->renameColumn('user_name', 'username');
        });
    }
}

Output

Column 'username' renamed to 'user_name' in 'users' table after migration runs.

Common Pitfalls

• Not installing doctrine/dbal causes errors because Laravel needs it to rename columns.
• Trying to rename a column that does not exist will cause migration failure.
• For some database types, renaming columns may not be supported or may require additional steps.

php

<?php
// Wrong: Missing doctrine/dbal package
Schema::table('users', function (Blueprint $table) {
    $table->renameColumn('old', 'new');
});

// Right: Install doctrine/dbal first
// composer require doctrine/dbal
Schema::table('users', function (Blueprint $table) {
    $table->renameColumn('old', 'new');
});

Quick Reference

Step	Command/Code	Description
1	composer require doctrine/dbal	Install package needed for renaming columns
2	php artisan make:migration rename_column_in_table	Create a new migration file
3	Schema::table('table', function (Blueprint $table) { $table->renameColumn('old', 'new'); });	Rename the column inside migration
4	php artisan migrate	Run the migration to apply changes

Key Takeaways

Always install the doctrine/dbal package before renaming columns in Laravel migrations.

Use the renameColumn method inside Schema::table to rename columns safely.

Test your migrations on a development database to avoid errors.

Provide a down method to reverse the rename for rollback support.