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

1 vote351 views1 answer
Error code 1055
SQL
2 votes359 views1 answer
Update trigger
SQL
0 vote388 views1 answer
Sql with example
SQL
0 vote402 views1 answer
How to find sql server installation folder
SQL
1 vote360 views1 answer
Select not matching data with join table
SQL
0 vote388 views1 answer
How to join result table in mysql
SQL
0 vote360 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote369 views1 answer
Test sql query
SQL
1 vote354 views4 answers
Postgres extract date from timestamp
SQL
0 vote361 views1 answer
Oracle sql drop table
SQL