Select table column in sql

/**
You must have all privillage to access this, else it will denaid access :)
**/

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'tableName';

Similar codes

-1 vote135 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote124 views1 answer
Sql select most frequent value in group
SQL
0 vote136 views1 answer
Mysql url data type
SQL
3 votes126 views2 answers
Sql server current date without time
SQL
0 vote157 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote110 views1 answer
Mysql see column types
SQL
0 vote132 views1 answer
Oracle array
SQL
0 vote136 views1 answer
Mysql set boolean default value
SQL
0 vote134 views1 answer
H2 auto increment and unique
SQL
0 vote116 views1 answer
Save single sql query result boolean spring boot
SQL