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 vote135 views1 answer
Get current date data in mysql
SQL
2 votes136 views1 answer
Q operator in oracle
SQL
2 votes169 views3 answers
How to replace null values in sql
SQL
2 votes137 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote147 views1 answer
Get from database the most recent data limit by 5
SQL
11 votes136 views3 answers
Sql_mode=only_full_group_by
SQL
2 votes143 views2 answers
Sql strip non alphanumeric characters
SQL
3 votes154 views1 answer
How to uninstall microsoft sql server
SQL
0 vote159 views1 answer
What is default mysql database password in linux
SQL
1 vote194 views1 answer
Oracle transaction rollback not working
SQL