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 vote175 views1 answer
Output table plsql
SQL
9 votes206 views4 answers
SQL Date Format
SQL
3 votes250 views1 answer
Oracle apex warn on unsaved changes
SQL
5 votes251 views2 answers
Add days in oracle sql
SQL
0 vote192 views1 answer
How to move a column to different spot mysql
SQL
0 vote204 views10 answers
Sql statement checker corrector
SQL
6 votes310 views1 answer
Sql insert values into table
SQL
0 vote177 views1 answer
What alter does in db
SQL
3 votes167 views2 answers
Pl sql escape '
SQL
0 vote216 views1 answer
Sql multiple into
SQL