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 vote268 views1 answer
Psql human readable
SQL
0 vote250 views1 answer
Google cloud sql postgres url example
SQL
-1 vote277 views2 answers
Sql truncate number
SQL
1 vote258 views2 answers
ImportError: No module named mysql.connector
SQL
6 votes258 views1 answer
Identify primary key in oracle table
SQL
27 votes266 views3 answers
Mysql show tables in database
SQL
1 vote266 views2 answers
Copy database mysql
SQL
0 vote260 views1 answer
Db format in quotation
SQL
13 votes257 views6 answers
Current date sql
SQL
1 vote243 views1 answer
Input in mysql
SQL