Answers for "how to get column name of table in sql"

SQL
5

get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'
Posted by: Guest on December-11-2020
3

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';
Posted by: Guest on November-14-2021
0

SQL column name

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'
Posted by: Guest on November-22-2021

Code answers related to "how to get column name of table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language