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 vote167 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote178 views1 answer
Mysql how to reset primary key
SQL
5 votes185 views3 answers
MySql get fields of table
SQL
0 vote190 views1 answer
Change filed order in mysql
SQL
2 votes245 views3 answers
Postgres create view
SQL
3 votes213 views4 answers
Mysql create table from select statement
SQL
0 vote188 views1 answer
Helptext in sql
SQL
0 vote208 views1 answer
Create function in microsoft sql server
SQL
2 votes179 views1 answer
Oracle index size
SQL
0 vote135 views1 answer
Count char in java
SQL