SQL column name

Get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

Select table column name 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';

SQL column name

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'

Source: stackoverflow.com

Similar codes

-1 vote303 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote261 views1 answer
How to get inserted id in sql server
SQL
1 vote283 views1 answer
Simple project for database
SQL
0 vote283 views2 answers
Sql trigger difference between for and after
SQL
7 votes279 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote264 views1 answer
Mysql export data with a where clause
SQL
0 vote330 views1 answer
Mysql streaming example
SQL
0 vote260 views1 answer
Postgresql inline table
SQL
1 vote272 views2 answers
Setval max id postgresql sequence
SQL
1 vote278 views1 answer
Postgres select as csv
SQL