How to select all column name from a table in laravel?

Question

I have tried to get all column names from a table Teller

Function:

public function getTableColumns($tables) {     return DB::select(DB::raw('SELECT                                      COLUMN_NAME,                                      DATA_TYPE,                                      COLUMN_DEFAULT                                 FROM                                      INFORMATION_SCHEMA.COLUMNS                                 WHERE                                      table_name = `Teller`')); } 

Answer 1

You can get all columns name by simply doing that...

use Illuminate\Support\Facades\Schema;  use Illuminate\Support\Facades\DB;  public function getTableColumns($table) {     return DB::getSchemaBuilder()->getColumnListing($table);      // OR      return Schema::getColumnListing($table);  }