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 votes117 views2 answers
Mysql create database
SQL
0 vote142 views1 answer
How to check event scheduler status mysql
SQL
0 vote127 views1 answer
Version and edition of SQL Server Database Engine
SQL
2 votes132 views2 answers
Insert all in sql
SQL
0 vote126 views1 answer
Apex for oracle 11g
SQL
4 votes120 views2 answers
Sql table
SQL
0 vote136 views1 answer
Renommer base sql
SQL
4 votes120 views1 answer
Delete record mysql query
SQL
0 vote176 views1 answer
MySQL update with subquery
SQL
0 vote115 views1 answer
Drop all tables in azure sql database
SQL