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 vote167 views1 answer
Php login system with admin features
PHP
0 vote152 views1 answer
Fakher ul islam khan
PHP
8 votes181 views1 answer
Laravel show routes artisan
PHP Laravel
7 votes171 views3 answers
Merge two arrays one as key to another php
PHP
0 vote162 views1 answer
Laravel schedule kernel code sample
PHP
0 vote161 views1 answer
Code to set error for du[licate entry in php
PHP
0 vote156 views1 answer
Take files from one folder and move to another folder in php
PHP
26 votes140 views6 answers
Php return json
PHP
14 votes186 views6 answers
Php string starts with
PHP
0 vote147 views1 answer
Php is_a
PHP