Answers for "how to obtain column names of the query sql"

get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

Posted by: Guest on December-11-2020

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 obtain column names of the query sql"