Show Laravel SQL from migation

Question

Is there a way to show the actual SQL that Laravel-4 will run against a database given a migration?

I would like to see how it will behave before I actually commit it to a database.

score 22 · Accepted Answer · answered Jun 16 '13 at 17:13

22

This does the trick:

php artisan migrate --pretend

answered Jun 16 '13 at 17:13

Jason Macgowan

Exceptionally useful for debugging valid PHP that generates invalid SQL. In my case, an the (optional) parameter for a decimal was not being specified $table->decimal(10,2) had a period instead of a comma. – David Hamilton Jun 06 '17 at 03:21

1 Answers1