The schema builder does not have the ability to create views so you have to write the sql necessary to create them manually in your migration classes.
Just create a migration like usual then delete everything in the up and down methods and replace it with the queries need to create and drop the view.
DB::statement('CREATE VIEW ...');
DB::statement('DROP VIEW ...');
Keep in mind this will only work if you are using mysql.
Last updated
10 months ago.
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast