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

5 votes227 views2 answers
Postgresql insert select
SQL
0 vote193 views1 answer
Sql DATE = GETDATE()
SQL
0 vote254 views1 answer
Postgres extract number from string
SQL
0 vote226 views1 answer
Postgres docs /copy metacomand
SQL
1 vote251 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote190 views1 answer
Doesn't have default value mysql
SQL
0 vote186 views1 answer
Oracle archivelog usage
SQL
0 vote189 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote182 views1 answer
Stuff in sql server
SQL
0 vote184 views1 answer
Oracle index hint
SQL