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 vote109 views1 answer
What is the use of index in mysql table
SQL
0 vote104 views1 answer
Mysql remove tabs from string
SQL
3 votes91 views1 answer
Difference sql vs mysql
SQL
0 vote101 views1 answer
Select all tables linked server sql
SQL
3 votes102 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote115 views1 answer
Get last three characters in mysql column
SQL
1 vote120 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote142 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote116 views1 answer
How get data from database if id not found then search another column
SQL
0 vote114 views1 answer
Rename view mysql
SQL