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 vote159 views1 answer
Sql server select ignore dupplicates
SQL
0 vote168 views1 answer
Intellij mysql set timezone
SQL
0 vote164 views1 answer
Postgresql array to rows
SQL
15 votes187 views4 answers
Sql update from select
SQL
2 votes150 views1 answer
Plsql block
SQL
0 vote203 views1 answer
Suhaib
SQL
2 votes142 views1 answer
Can you use a where clause for a child query
SQL
2 votes166 views1 answer
How to show the whole table in sql
SQL
0 vote238 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote151 views1 answer
Sql select most frequent value in group
SQL