tsql get column names code example

Example 1: get column name sql server

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

Example 2: Returns all column names as a list

# Returns all column names as a list

df.columns
#['age', 'name']