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 vote268 views1 answer
Database springboot
SQL
0 vote271 views1 answer
How to check if there is no database schema
SQL
0 vote276 views1 answer
Output to file mysql
SQL
4 votes340 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
4 votes288 views2 answers
Sql server date now
SQL
5 votes295 views3 answers
Bash: mysql: command not found
SQL
3 votes271 views3 answers
Stop mysql service ubuntu
SQL
4 votes281 views1 answer
Select first and last row sql
SQL
37 votes461 views3 answers
Sql check duplicate value in column
SQL
0 vote269 views1 answer
Oracle search in date columns
SQL