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

3 votes367 views2 answers
Sql add year to date
SQL
0 vote321 views6 answers
Unique key in sql
SQL
0 vote336 views1 answer
Oracle sql drop table
SQL
5 votes357 views3 answers
Show indexes mysql
SQL
0 vote375 views2 answers
Insert data mysql with cmd
SQL
1 vote342 views1 answer
List all triggers in SQL Server
SQL
1 vote327 views1 answer
Mysql Case sum
SQL
4 votes335 views1 answer
Oracle table statistics last analyzed
SQL
1 vote379 views1 answer
Oracle see column type
SQL
0 vote332 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL