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 vote133 views1 answer
Double in sql server example
SQL
0 vote140 views1 answer
Sql list dates between two dates
SQL
0 vote124 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote145 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
-1 vote136 views1 answer
Export mysql table to file
SQL
2 votes134 views1 answer
Oracle list duplicates
SQL
0 vote124 views1 answer
Mysql sql select one day before
SQL
0 vote158 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
1 vote158 views1 answer
Count of tables in database mysql
SQL
0 vote132 views1 answer
Can we rollback in sql
SQL