How to get column names from table in Laravel

• Laravel get column names from a table

  --PATH routes\web.php

  Route::get('/get-table-columns', function(){
      $table = 'users';
      return DB::getSchemaBuilder()->getColumnListing($table);
  });
  
  //Output:
  //["id","name","email","email_verified_at","password","remember_token","created_at","updated_at"]
  
  //Methods you can use to get the list of columns from a table.
  Schema::getColumnListing($table);
  //Or
  DB::getSchemaBuilder()->getColumnListing($table);
  
  //You can easily use facade (Schema and DB facade) using use statement. 
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Support\Facades\DB;
  

  You have to copy/paste code in routes\web.php and visit URL http://localhost:8000/get-table-columns to get all column (field) names of a specified table.

Back to code snippet queries related laravel