Answered by : faithful-fish-4uu3s6wj4zll
public function up()
{ Schema::table('table', function($table) { $table->dropColumn('column_name'); });
}
Source : | Last Update : Thu, 23 Apr 20
Answered by : james-juson
// 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 : https://laravel.com/docs/7.x/migrations#dropping-columns | Last Update : Mon, 25 Jan 21
Answered by : stefano-de-cillis
Class RemoveCommentViewCount extends Migration { public function up() { Schema::table('articles', function($table) { $table->dropColumn('comment_count'); $table->dropColumn('view_count'); }); } public function down() { Schema::table('articles', function($table) { $table->integer('comment_count'); $table->integer('view_count'); }); } }
Source : https://stackoverflow.com/questions/37631682/removing-column-from-database-in-laravel-5-2/49940617 | Last Update : Thu, 26 Mar 20
Answered by : engineer-wajid-ali
Update Table
migrate:fresh Drop all tables and re-run all migrations
migrate:install Create the migration repository
migrate:refresh Reset and re-run all migrations
migrate:reset Rollback all database migrations
migrate:rollback Rollback the last database migration
migrate:status Show the status of each migration
for specific table
php artisan migrate:refresh --path=/database/migrations/table_name.php
Source : | Last Update : Fri, 13 May 22
Answered by : muhammad-kaleem
Class RemoveCommentViewCount extends Migration { public function up() { Schema::table('table', function($table) { $table->dropColumn('coulmn_name'); }); } public function down() { Schema::table('table', function($table) { $table->integer('column_name'); }); } }
Source : https://stackoverflow.com/questions/37631682/removing-column-from-database-in-laravel-5 | Last Update : Tue, 23 Nov 21
Answered by : alberto-peripolli
Schema::drop('users');
Schema::dropIfExists('users');
Source : | Last Update : Mon, 04 May 20
Answered by : yousef-qaoud
Schema::table('clients', function (Blueprint $table) { $table->string('UserDomainName');
});
Source : https://stackoverflow.com/questions/45819718/laravel-migrations-dropping-columns | Last Update : Thu, 19 May 22