php artisan make:migration drop_name_table
// 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');
});
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
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');
});
}
}
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');
});
}
}
Schema::drop('users');
Schema::dropIfExists('users');
//Get all the table names
$all_table_names = Schema::getConnection()->getDoctrineSchemaManager()->listTableNames();
foreach ($all_table_names as $name) {
//if you don't want to truncate migrations in Database
if ($name == 'migrations') {
continue;
}
DB::table($name)->truncate();
}
foreach(DB::select('SHOW TABLES') as $table) {
$all_table_names = get_object_vars($table);
Schema::drop($all_table_names[key($all_table_names)]);
}
Schema::table('clients', function (Blueprint $table) {
$table->string('UserDomainName');
});
$table->dropColumn('column_name');