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 votes221 views1 answer
Oracle drop user
SQL
1 vote198 views1 answer
Update and replace mysql
SQL
2 votes195 views1 answer
Drop table purge
SQL
0 vote212 views1 answer
Mysql database hyphen
SQL
1 vote209 views1 answer
Postgres power
SQL
1 vote209 views1 answer
Postgres check for foreign key
SQL
0 vote199 views1 answer
Sql change date format
SQL
0 vote209 views1 answer
Foreign key multiple columns
SQL
18 votes201 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote200 views1 answer
Sql server union if table exist
SQL