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 vote202 views1 answer
Output to file mysql
SQL
0 vote217 views2 answers
Default constraint in ms sql
SQL
1 vote217 views2 answers
Oracle replace
SQL
0 vote216 views1 answer
Inserting data into different tables at once in oracle sql
SQL
1 vote232 views2 answers
Snowflake alter column data type
SQL
19 votes206 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote214 views1 answer
Incorrect string value: mysql
SQL
0 vote223 views2 answers
How to tun mysql on ubunto
SQL
0 vote170 views1 answer
Import sql file in mysql linux
SQL
0 vote215 views1 answer
Display first three characters sql
SQL