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

3 votes128 views4 answers
Order by desc postgres
SQL
2 votes137 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote188 views1 answer
Scheduled mysql database backup in linux
SQL
38 votes208 views6 answers
Ubuntu install mysql client
SQL
14 votes133 views5 answers
Sql oracle limit
SQL
0 vote130 views1 answer
What is SQL data store?
SQL
0 vote147 views1 answer
Month mysql
SQL
0 vote137 views2 answers
Close external port 3306 with iptables
SQL
0 vote136 views1 answer
Como hacer una consulta en sql
SQL
0 vote123 views1 answer
18446744073709551615 mariadb left join order by
SQL