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 vote123 views1 answer
Decalre temp table sql
SQL
1 vote122 views1 answer
Sql query row number group by
SQL
0 vote104 views1 answer
Online sql testing tool
SQL
1 vote126 views3 answers
Connect to mysql c# connection string C#
SQL
2 votes146 views1 answer
Mysql select true or false
SQL
1 vote146 views1 answer
Psql view enum values
SQL
10 votes113 views4 answers
Primary key sql
SQL
0 vote125 views1 answer
Add two days to current date in sql when creating tables
SQL
2 votes113 views2 answers
Exec procedure pl sql
SQL
1 vote124 views1 answer
Too many connections mysql
SQL