query ambil tabel

public function component(Request $request) {
        if(!is_null($request->Key)) {
            $alltable = DB::select('SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = \''. env("DB_DATABASE", "kitchenware").'\'
             AND TABLE_NAME != \'access_settings\'
             AND TABLE_NAME != \'account_debts\'
             AND TABLE_NAME != \'accounting_v2s\'
             AND TABLE_NAME != \'balances_v2s\'
             AND TABLE_NAME != \'bill_v2s\'
             AND TABLE_NAME != \'bill_v3s\'
             AND TABLE_NAME != \'branch_incomes\'
             AND TABLE_NAME != \'claim_histories\'
             AND TABLE_NAME != \'debt\'
             AND TABLE_NAME != \'delivery_order_v2s\'
             AND TABLE_NAME != \'ledgers_v2s\'
             AND TABLE_NAME != \'migrations\'
             AND TABLE_NAME != \'office_spendings\'
             AND TABLE_NAME != \'petty_cash_histories\'
             AND TABLE_NAME != \'purchases\'
             AND TABLE_NAME != \'receipt_v2s\'
             AND TABLE_NAME != \'salary_components\'
             AND TABLE_NAME != \'stock_in_v2s\'
             AND TABLE_NAME != \'stock_out_v2s\'
             AND TABLE_NAME != \'stock_in_v3s\'
             AND TABLE_NAME != \'stock_out_v3s\'
             AND TABLE_NAME != \'transaction_v2s\'
             AND TABLE_NAME != \'sales\'
             AND TABLE_NAME != \'sales_trackers\'
             AND TABLE_NAME != \'trial_balances_v2s\'
             AND TABLE_NAME != \'users\'');
            $listComponent = array();
            foreach($alltable as $table) {
                $column = DB::select('SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'' .$table->TABLE_NAME.'\'');
                $content = array(
                    'ComponentName' => $table->TABLE_NAME,
                    'Columns' => $column
                );
                array_push($listComponent, $content);
            }
            return response()->json($listComponent);
        } else {
            return response()->json(['message' => 'Unauthorized Request']);
        }
    }