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

2 votes342 views2 answers
Mysql on duplicate key ignore
SQL
0 vote339 views1 answer
Ora 00001 error catch plsql
SQL
7 votes336 views2 answers
N highest salary in sql
SQL
5 votes370 views1 answer
AND OR NOT operators sql
SQL
0 vote361 views1 answer
Python list from sql
SQL
0 vote329 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote336 views1 answer
Insufficient memory to excute the sql query
SQL
1 vote325 views1 answer
Sql comment header
SQL
14 votes380 views4 answers
Import database through command line
SQL
3 votes374 views1 answer
Create a table with an id in mysql
SQL