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

34 votes169 views6 answers
Install mysql client ubuntu
SQL
0 vote167 views1 answer
Get first monday of month sql
SQL
1 vote177 views2 answers
Pad zero sql server
SQL
0 vote175 views1 answer
Exectuer myssql .sql
SQL
1 vote161 views1 answer
Oracle index partition
SQL
0 vote189 views2 answers
Generate sql trigger through ef migration
SQL
5 votes175 views3 answers
Oracle list columns in schema
SQL
0 vote173 views1 answer
Sql query to return field name of a table
SQL
3 votes182 views1 answer
Sql multi column index performance
SQL
0 vote164 views1 answer
Mysql insert into select with recursive
SQL