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 vote267 views1 answer
Query archive mode
SQL
0 vote280 views1 answer
Postgresql delete limit
SQL
0 vote282 views1 answer
Closure in sql
SQL
12 votes249 views1 answer
Create column sql server
SQL
79 votes493 views6 answers
Grepper code
SQL
0 vote262 views1 answer
Sql select inside select sub query
SQL
0 vote250 views1 answer
How to check if there is no database schema
SQL
0 vote260 views1 answer
Multiple tricky query in sql server
SQL
1 vote262 views1 answer
Oracle rolling back
SQL
1 vote279 views1 answer
Replace all numbers in mysql
SQL