Skip to content
Advertisement

Make column not nullable in a Laravel migration

I’m writing a migration to make certain columns in a table nullable right now. For the down function, I of course want to make those columns not nullable again. I looked through the schema builder docs, but couldn’t see a way to do this.

Any help would be appreciated.

Advertisement

Answer

Prior to Laravel 5, there was no Laravel native way of altering an existing table column using the schema builder. You’d need to use raw queries for this.

However, as of Laravel 5 you can use:

$table->string('foo')->nullable(false)->change();

You must have the dbal dependency prior to running the above command:

composer require doctrine/dbal
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement