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 votes245 views3 answers
Mysql order by list
SQL
12 votes235 views4 answers
Mysql version query
SQL
6 votes236 views5 answers
Mysql get last insert id
SQL
0 vote235 views1 answer
Postgres drop type
SQL
0 vote242 views3 answers
Remove folders from remote git
SQL
0 vote244 views1 answer
Sql put two columns into one
SQL
0 vote231 views2 answers
Find lowest number in sql
SQL
1 vote274 views1 answer
Sql server set variable if exists
SQL
3 votes328 views1 answer
Oracle cannot access v$session
SQL
0 vote190 views1 answer
Hangfire clean script
SQL