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 vote226 views1 answer
Query to insert image
SQL
1 vote196 views1 answer
Oracle list datafiles in tablespace
SQL
-1 vote201 views2 answers
Get day in sql
SQL
4 votes288 views4 answers
Update select mysql
SQL
9 votes212 views4 answers
Mysql show table fields
SQL
14 votes217 views1 answer
Oracle alter table add column not null
SQL
1 vote202 views1 answer
Sql where last 12 months
SQL
2 votes202 views2 answers
Function in sql
SQL
18 votes165 views2 answers
How to get all the tables displayed in oracle
SQL
3 votes202 views1 answer
APEX elapsed time
SQL