Laravel drop column

Laravel foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
});

Laravel migration remove column

public function up()
{
  Schema::table('table', function($table) {
    $table->dropColumn('column_name');
  });
}

Laravel before migration

Schema::table('users', function ($table) {
    $table->string('email')->after('id')->nullable();
});

Laravel drop column

// To drop a column, use the dropColumn method on the schema builder.
// Before dropping columns from a SQLite database, you will need to add
// the doctrine/dbal dependency to your composer.json file and run the
// composer update command in your terminal to install the library:

Schema::table('users', function (Blueprint $table) {
    $table->dropColumn('votes');
});

Source: laravel.com

Laravel create migration

php artisan make:migration add_votes_to_users_table --table=users

php artisan make:migration create_users_table --create=users

Source: laravel.com

Laravel migration add unique column

Schema::table('tableName', function($table)
{
    $table->string('column-name')->unique(); //notice the parenthesis I added
});

Similar codes

0 vote222 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote255 views2 answers
Laravel permission to vuejs
PHP Laravel
0 vote242 views1 answer
Laravel unique column except self
PHP Laravel
12 votes271 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
0 vote223 views1 answer
Laravel passport vue 401 Unauthorized
PHP Laravel
20 votes240 views3 answers
Make specific migration laravel
PHP Laravel
14 votes225 views6 answers
Update query in laravel eloquent
PHP Laravel
-1 vote232 views4 answers
Laravel create command tutorial
PHP Laravel
2 votes254 views2 answers
Laravel show table columns
PHP Laravel
15 votes215 views6 answers
Laravel migration default value
PHP Laravel