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 vote200 views3 answers
Select top 10 rows in sql
SQL
0 vote154 views1 answer
How to reset the database value in SQL server
SQL
2 votes134 views2 answers
Get all columns from table sql
SQL
1 vote168 views1 answer
Mysql view curren querys
SQL
0 vote116 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote126 views0 answer
SQL
1 vote156 views1 answer
Count mysql server db tables
SQL
1 vote150 views1 answer
Too many connections mysql
SQL
19 votes157 views3 answers
Grant mysql
SQL
5 votes179 views1 answer
Oracle ora-00054 resource busy
SQL