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

2 votes278 views2 answers
Mysql user access to database
SQL
1 vote305 views1 answer
Sql how to replace full stop
SQL
0 vote302 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
4 votes269 views3 answers
Sqlite show columns
SQL
0 vote271 views1 answer
Mysql preg replace
SQL
7 votes256 views1 answer
Query delete duplicates
SQL
14 votes293 views2 answers
Oracle add attribute to table
SQL
0 vote305 views1 answer
Sqlalchemy _in array sqlite
SQL
9 votes264 views4 answers
How to remove duplicate in sql
SQL
1 vote226 views1 answer
Postgres grant read only access to database
SQL