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 vote110 views4 answers
What is unique key in sql
SQL
0 vote95 views1 answer
Group by 15 minute interval sql server
SQL
0 vote82 views2 answers
Influxdb delete measurement based on date
SQL
0 vote100 views1 answer
Mysql_error replacement
SQL
1 vote99 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote105 views1 answer
Ssql to lowercqse
SQL
1 vote115 views1 answer
Sql first day quarter
SQL
0 vote111 views3 answers
Drop multiple columns in sql
SQL
0 vote107 views2 answers
Select index table oracle
SQL
1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL