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

1 vote111 views1 answer
Sql headers delphi
SQL
0 vote112 views1 answer
Get yesterday date ISO in psql
SQL
0 vote132 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote110 views2 answers
SQL Server Standard
SQL
1 vote109 views1 answer
Select dba users oracle
SQL
0 vote103 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
31 votes126 views3 answers
Sql count
SQL
-1 vote108 views1 answer
How to use update trigger in sql
SQL
0 vote113 views1 answer
Mysql add comment to column
SQL
0 vote152 views1 answer
Postgres execute multiple sql file from command line
SQL