如何从laravel的表中选择所有列名?

How to select all column name from a table in laravel?(如何从laravel的表中选择所有列名?)

问题描述

我尝试从表中获取所有列名Teller

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

功能:

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

推荐答案

您可以通过简单的操作获得所有列名...

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

use IlluminateSupportFacadesSchema;

use IlluminateSupportFacadesDB;

public function getTableColumns($table)
{
    return DB::getSchemaBuilder()->getColumnListing($table);

    // OR

    return Schema::getColumnListing($table);

}

这篇关于如何从laravel的表中选择所有列名?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！