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

5 votes223 views1 answer
Mysql last day of next month
SQL
1 vote164 views1 answer
Postgres get timestamp
SQL
0 vote174 views1 answer
Sql remove first character from string
SQL
15 votes363 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote198 views1 answer
Oracle user last connection date
SQL
0 vote184 views1 answer
Postgres copy command
SQL
0 vote167 views1 answer
Show function mysql
SQL
1 vote136 views1 answer
Convert money to varchar sql server
SQL
6 votes170 views2 answers
Mysql execute file
SQL
1 vote164 views2 answers
Oracle difference between two dates in seconds
SQL