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 vote190 views3 answers
Java hide mysql login credentials
SQL
0 vote181 views1 answer
Compare two tables to find unmatched records
SQL
0 vote200 views1 answer
Postgresql create table many-to-many
SQL
0 vote174 views1 answer
Psql check if value in array
SQL
2 votes169 views1 answer
Check isolation level in mysql
SQL
6 votes177 views2 answers
Mysql set primary key
SQL
2 votes171 views1 answer
Mysql select random id from table
SQL
1 vote178 views1 answer
Mysql view current queries
SQL
5 votes175 views1 answer
Oracle find foreign key dependencies
SQL
2 votes164 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL