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
Hw to delete a procedure in pl sql
SQL
15 votes249 views3 answers
Mysql update add to existing value
SQL
2 votes242 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote318 views1 answer
Oracle db timestamp auto add
SQL
0 vote229 views1 answer
Select last N rows mysql
SQL
1 vote248 views1 answer
Postgresql substring last
SQL
0 vote232 views1 answer
Datetime postgres typeorm
SQL
2 votes232 views3 answers
Current month mysql query
SQL
0 vote234 views1 answer
Sql select lowest value row
SQL
0 vote234 views1 answer
Mysql persistence.xml
SQL