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

1 vote188 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote258 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote269 views1 answer
Sql server is not
SQL
4 votes192 views4 answers
Sqlite describe table
SQL
3 votes198 views2 answers
Mysql time
SQL
1 vote183 views1 answer
Sql server select rows by distinct column
SQL
0 vote220 views4 answers
Forenkey code alchemy sql
SQL
1 vote349 views1 answer
Mysql data from file
SQL
0 vote204 views1 answer
How to delete python anywhere mysql database
SQL
2 votes177 views2 answers
Get all columns from table sql
SQL