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 views1 answer
OFFSET consulta mysql
SQL
5 votes182 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote199 views1 answer
Full outer join in mariadb mysql
SQL
0 vote225 views1 answer
How to fetch data from database in sql
SQL
0 vote183 views1 answer
Postgres set default schema
SQL
15 votes185 views2 answers
How to drop database name in postgresql
SQL
2 votes199 views1 answer
Oracle find unusable indexes
SQL
0 vote169 views1 answer
Get only first row mysql
SQL
8 votes187 views2 answers
Alert table name mysql
SQL
4 votes199 views3 answers
Check if two date ranges overlap sql server
SQL