/    Sign up×
Bounties /Pin to ProfileBookmark

Is there a way to modify an existing column in a table in the database using a migration in Laravel?

to post a answer
Laravel

1 Replies

Copy linkTweet thisAlerts:
@MichaelDelgadoAug 11.2022 — Yes there is, but you would need to include another composer package (doctrine/dbal) in order to do this. More info found here but in short, after using composer require doctrine/dbal you can then make a new migration which would be able to then utilize the change() method on the column, for example changing the name column on the users table to now have a size of 50 and be nullable would be the following:
Schema::table('users', function (Blueprint $table) {
$table->string('name', 50)->nullable()->change();
});
×

Success!

Help @JacobBarker spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 7.21,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ,
analytics: Fullres
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: Anonymous,
tipped: article
amount: 1000 SATS,

tipper: Anonymous,
tipped: article
amount: 1000 SATS,

tipper: @Nanditha,
tipped: article
amount: 1000 SATS,
)...