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 vote348 views1 answer
Allow null in psql
SQL
0 vote319 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote309 views1 answer
Mysql select row with min date
SQL
8 votes354 views2 answers
How to fetch data from database without last column
SQL
0 vote413 views1 answer
How to subquey to do not load in live database in
SQL
0 vote510 views1 answer
Sql change a colum to unique
SQL
0 vote313 views1 answer
Mysql trim characters
SQL
4 votes395 views2 answers
Delete all table oracle
SQL
0 vote351 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote369 views1 answer
Mysql update inner
SQL