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 vote152 views1 answer
Postgresql array to rows
SQL
7 votes153 views2 answers
Create mysql user
SQL
1 vote176 views1 answer
Continue in sql
SQL
4 votes163 views1 answer
Is there any command to change postgres password
SQL
4 votes139 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote146 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote150 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
16 votes139 views6 answers
Mysql find and replace
SQL
1 vote105 views1 answer
Convert money to varchar sql server
SQL
0 vote139 views1 answer
Show create table in postgresql
SQL