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

0 vote320 views1 answer
Codeigniter dbforge add index
SQL
28 votes329 views4 answers
Show tables mysql
SQL
0 vote326 views1 answer
How to get initials in sql
SQL
0 vote396 views1 answer
Sql datum formatieren
SQL
11 votes362 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote343 views1 answer
SAP Return
SQL
2 votes377 views1 answer
Postgresql group by month and year
SQL
7 votes380 views2 answers
How to create index mysql
SQL
0 vote336 views1 answer
Mysql join only one column
SQL
3 votes333 views1 answer
Force using index oracle
SQL