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

7 votes102 views2 answers
Mysql db size
SQL
3 votes112 views6 answers
DB::table('users')->get();
SQL
1 vote108 views1 answer
Age postgres
SQL
2 votes104 views2 answers
Insert all in sql
SQL
0 vote91 views2 answers
Insert into
SQL
0 vote127 views2 answers
Plpgsql
SQL
0 vote95 views1 answer
Ignore case in string sql
SQL
0 vote127 views1 answer
Create table with timestamp mysql youtube
SQL
-1 vote106 views2 answers
Postgresql get last 10 records
SQL
0 vote104 views1 answer
Utiliser sql ligne de commande
SQL