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

9 votes232 views3 answers
Laravel database seeder medium
PHP Laravel
26 votes292 views6 answers
Laravel model with migration
PHP Laravel
22 votes278 views2 answers
Where status is null sql in laravel
PHP Laravel
7 votes258 views2 answers
Laravel collection isEmpty
PHP Laravel
0 vote277 views1 answer
Laravel excel set cell height
PHP Laravel
4 votes280 views2 answers
Validate year laravel
PHP Laravel
14 votes252 views6 answers
Update query in laravel eloquent
PHP Laravel
0 vote236 views1 answer
Laravel mix build as umd
PHP Laravel
7 votes244 views2 answers
Laravel unique multiple columns
PHP Laravel
0 vote249 views1 answer
Laravel bd query
PHP Laravel