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

1 vote207 views1 answer
Php decode html special characters
PHP
0 vote229 views1 answer
How to read laravel query string with dash
PHP Laravel
22 votes198 views5 answers
Get logged user id laravel
PHP
18 votes221 views3 answers
Laravel blade for loop
PHP
3 votes208 views4 answers
Input if not null laravel
PHP
2 votes226 views1 answer
How send user to 404 page if not exist page in laravel
PHP Laravel
0 vote188 views1 answer
Supprimer un cookie avec un input en php
PHP
1 vote212 views2 answers
Wordpress get link to post by id
PHP Wordpress
1 vote289 views1 answer
Bitrix is admin
PHP
7 votes301 views4 answers
Laravel validation date time format
PHP Laravel