How to Get an Array with Column Names of a Table

How to get an array with column names of a table

Suppose you have a Post model:

Post.column_names
# or
Post.columns.map { |column| column.name }

It will return an array with column names of the table 'posts'.

Create a new column with an array of column names based on condition

Consider below approach

select *, 
  regexp_extract_all(translate(to_json_string(t), '{}"', ''), r'(\w+):1') as Array_col
from mytable t       

if applied to sample data in your question - output is

Create array with column names in BigQuery

You should be able to achieve what you want with the following:

DECLARE column_names ARRAY <STRING>
SET column_names = (SELECT arraY_agg(column_name) FROM Books1.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'table1'
);

Adding array_agg makes the query return an array of the column names.

Creating an array of column names in Microsoft Server SQL

SELECT COLUMN_NAME FROM
(
  SELECT ROW_NUMBER() OVER(ORDER BY ORDINAL_POSITION) Num, COLUMN_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME = N'tablename'
) A
WHERE NUM = 1

ORDINAL_POSITION is nothing but "column identification number".

How to get table column names as array from model

You can use the getColumnListing() method:

use Schema;
Schema::getColumnListing($this->getTable())

JScript - Array with columns from table

You could do something like this using vanilla javascript

let columnData = Array.from(table.rows).
                 slice(1, table.rows.length).
                 map(row =>Array.from(row.cells).map(x => x.innerText)).
                 reduce((acc,rowData)=>{
                   rowData.forEach((value,index)=>{
                   acc[index]= acc[index] || [ ]
                   acc[index].push(value)
                 }) 
                 return acc },[])

let table = document.getElementById('tab')debuggerlet headers = Array.from(table.rows[0].cells).map(x => x.innerText)let columnData = Array.from(table.rows).      slice(1, table.rows.length).      map(row =>Array.from(row.cells).map(x => x.innerText))     .reduce((acc,rowData)=>{           rowData.forEach((value,index)=>{           acc[index]= acc[index] || [ ]           acc[index].push(value) })      return acc },[])console.log(headers)console.log(columnData)

<table id="tab">  <tr>    <th>      Name    </th>    <th>      Age    </th>    <th>      Location    </th>  </tr>
  <tr>    <th>      Jason    </th>    <th>      22    </th>    <th>      Texas    </th>  </tr>  <tr>    <th>      Lawson    </th>    <th>      21    </th>    <th>      Florida    </th>  </tr>  <tr>    <th>      Jose    </th>    <th>      25    </th>    <th>      London    </th>  </tr>
</table>

CREATE OR REPLACE PROCEDURE get_columns(TABLE_NAME VARCHAR)
RETURNS ARRAY
LANGUAGE JAVASCRIPT
AS
$$
var stmt = snowflake.createStatement({
    sqlText: "SELECT * FROM " + TABLE_NAME + " LIMIT 1;",    
});
stmt.execute();

var cols=[];
for (i = 1; i <= stmt.getColumnCount(); i++) {
  cols.push(stmt.getColumnName(i));
}
return cols
$$
;