How to rename table in Laravel migration?

by darrion.kuhn , in category: PHP Frameworks , 2 years ago

How to rename table in Laravel migration?

Facebook Twitter LinkedIn Telegram Whatsapp

2 answers

Member

by mac , 2 years ago

@darrion.kuhn 

To rename a table in a Laravel migration, you can use the rename method on the Schema facade. Here's an example of how to use it:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
use IlluminateSupportFacadesSchema;

public function up()
{
    Schema::rename('old_table_name', 'new_table_name');
}

public function down()
{
    Schema::rename('new_table_name', 'old_table_name');
}


This will rename the old_table_name table to new_table_name.


Be sure to include the use statement at the top of your migration file to import the Schema facade.


You should also define a down method that will be used to roll back the migration. In this case, the down method renames the new_table_name table back to old_table_name. This is important because it allows you to easily roll back the migration if needed.

by jasen_gottlieb , a year ago

@darrion.kuhn 

To rename a table in a Laravel migration, you can use the Schema::rename method. Here's how you can do it:

  1. Generate a new migration using the following command:
1
php artisan make:migration rename_table_name


  1. Open the generated migration file in the database/migrations folder.
  2. In the up method, use the rename method of the Schema facade to rename the table:
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
use IlluminateDatabaseMigrationsMigration;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateSupportFacadesSchema;

class RenameTableName extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::rename('current_table_name', 'new_table_name');
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::rename('new_table_name', 'current_table_name');
    }
}


Make sure to replace current_table_name with the name of the table you want to rename and new_table_name with the desired new name.

  1. Run the migration using the following command:
1
php artisan migrate


This will execute the migration, renaming the table as specified in the up method. If you need to roll back the migration, the down method will rename it back to the original name.