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

1 vote309 views1 answer
Create another table from existing table sql oracle
SQL
0 vote278 views1 answer
Concatenate columns in table
SQL
0 vote310 views1 answer
Alter boolean column postgresql
SQL
0 vote359 views1 answer
Reindexing all tables sql server
SQL
0 vote282 views1 answer
Select top 3 sql
SQL
1 vote309 views1 answer
Postgres set sequence value to max id
SQL
0 vote267 views1 answer
Metada in sql
SQL
4 votes275 views1 answer
Update table from another table oracle
SQL
6 votes320 views4 answers
Mysql group by date
SQL
0 vote300 views1 answer
Max mysql
SQL