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 vote204 views1 answer
Hoq to import database source
SQL
15 votes196 views4 answers
Mysql where value is null
SQL
8 votes228 views2 answers
Default sql server port
SQL
1 vote188 views1 answer
Convert rows to string sql server
SQL
0 vote195 views1 answer
Mysql select inside sum
SQL
10 votes208 views2 answers
Oracle alter sequence nextval
SQL
2 votes205 views1 answer
Postgresql change value in column
SQL
0 vote205 views1 answer
Sql get number of days between two dates
SQL
0 vote198 views1 answer
C# check if mysql query modified rows
SQL
0 vote195 views2 answers
Mysql select date from datetime
SQL