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 vote318 views1 answer
Influxdb export to csv
SQL
4 votes296 views1 answer
Postgresql create table with index
SQL
0 vote299 views1 answer
Mysql add to value
SQL
0 vote269 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote340 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote322 views1 answer
Postrgres trunc
SQL
2 votes289 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote305 views1 answer
Get the previous column of a table in mysql
SQL
9 votes309 views5 answers
Sql limit
SQL
0 vote320 views1 answer
Sqlalchemy orm duplicate
SQL