Schema Builder : Create Table if not exists

Question

I am using below code in Schema Builder to create table.

Schema::create('tblCategory', function (Blueprint $table) {
    $table->increments('CategoryID');
    $table->string('Category', 40);
    $table->unique('Category', 'tblCategory_UK_Category');
    $table->timestamps();
});

Here is the problem is, if I have to create the new table, all old scripts runs and show error that table already exists.

is there any way to create table if not exists using Schema builder ?

And you run `php artisan migrate` ? If the file was run successfully, it should store that in the database so it won't run the file again — Morten, Feb 17 '16 at 21:20
I am using `php artisan migrate:refresh` and next time, it tries to rerun the old scripts. — Pankaj, Feb 17 '16 at 21:21
No errors? (except trying to create a table that already exists) Is your migration table populated with the filenames of which it tries to run? If you try it on a new database, will it succeed without any errors, and therefore populate the migrations table with successfull migrated files? — Morten, Feb 17 '16 at 21:37

score 104 · Accepted Answer · edited Mar 27 '23 at 08:15

104

Try this for create table if doesn't exist

use Illuminate\Support\Facades\Schema;

if (!Schema::hasTable('tblCategory')) {
     Schema::create('tblCategory', function($table){
            $table->engine = 'InnoDB';
            $table->increments('CategoryID');
            $table->string('Category', 40);
            $table->unique('Category', 'tblCategory_UK_Category');
            $table->timestamps();
    });
}

edited Mar 27 '23 at 08:15

Community

1
1

answered Feb 18 '16 at 05:57

paranoid

6,799
19
49
86

10

You can also do `if (Schema::hasTable('tblCategory')) { return; }` before adding it instead. – Sean the Bean Sep 13 '16 at 17:22
1

hi is this line of code if (!Schema::hasTable('tblCategory')) { // create the tblCategory table } if table exists? correct? – Software Developer Nov 01 '18 at 16:45

score 6 · Answer 2 · edited May 23 '17 at 12:34

6

Please check the answer here

To create a new table there is only one check by Laravel Schema function hasTable.

But if you want to drop any table before checking its existence then Schema have a function called dropIfExists.

Schema::dropIfExists('table_name');

It will drop the table if table will exist.

edited May 23 '17 at 12:34

Community

1
1

answered May 03 '17 at 06:14

Brn.Rajoriya

1,534
2
23
35

1

Be careful while using this, it'll delete your existing table along with data. – Imran Zahoor Oct 31 '22 at 17:15

score 1 · Answer 3 · answered May 18 '18 at 23:12

DB::transaction(function () {
        // Create your table here with schema builder.
});

If an exception is thrown within the transaction Closure, the transaction will automatically be rolled back. So trying to create a table already existing will throw an error. Most database transactions should have this closure in Laravel.

https://laravel.com/docs/5.6/database

Schema Builder : Create Table if not exists

3 Answers3

Linked