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 vote382 views1 answer
Time data type in mysql
SQL
0 vote370 views1 answer
Sql quary intervewi question
SQL
1 vote377 views1 answer
Postgresql how to show table names
SQL
0 vote344 views1 answer
Azure sql server check foreign key
SQL
0 vote362 views1 answer
How to login to mysql in homestead
SQL
0 vote360 views1 answer
Sql insert query list of dictionaries
SQL
3 votes380 views1 answer
Query less than datetime sql
SQL
0 vote329 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
10 votes383 views5 answers
Create table mysql query
SQL
5 votes339 views2 answers
Sql server check port number
SQL