How to set a table comment using Laravel Schema Builder

Question

How to set a table comment using Laravel Schema Builder?

Column Set:

public function up() { Schema::create('vendors', function (Blueprint $table) { $table->comment('not working - error'); // not working - error $table->increments('id'); $table->string('vendor', 255)->comment('Some comment.'); $table->timestamps(); }); } 

But for the table?

Answer 1

Well, I don't have a good answer for you, but at least it works.

Here he is:

 public function up() { $tableName = 'vendors'; Schema::create($tableName, function (Blueprint $table) { $table->increments('id'); $table->string('vendor', 255)->comment('Some comment.'); $table->timestamps(); }); DB::statement("ALTER TABLE `$tableName` comment 'My comment'"); } 

Just add a DB statement after creating the table.

Answer 2

Comment in database migration schema

When creating a Thats Time migration table, if you need a comment in the coloumn name, you can use.

  Schema::table('users', function (Blueprint $table) { $table->tinyInteger('status')->comment('0 = Inactive, 1 = Active'); }) 

;