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

2 votes157 views1 answer
Showing database table in php
PHP
0 vote133 views2 answers
Laravel file path
PHP
0 vote121 views1 answer
Php get current datetime in us chicago
PHP
13 votes98 views3 answers
Laravel date between
PHP
17 votes108 views5 answers
Wordpress debug mode
PHP
20 votes100 views4 answers
Array_search function in php
PHP
0 vote102 views1 answer
Unlink is a directory laravel
PHP
0 vote110 views2 answers
Column of csv to array php
PHP
1 vote121 views2 answers
Laravel model set new attribute
PHP
7 votes112 views6 answers
Unique validation on update laravel
PHP