Answers for "sql how to get the column names in a table"

SQL
3

get column name sql server

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

get table column names sql ssms

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Your Table Name'
ORDER BY COLUMN_NAME

-- IS_NULLABLE returns yes or no depending on null or not null
Posted by: Guest on January-15-2021

Code answers related to "sql how to get the column names in a table"

Code answers related to "SQL"

Browse Popular Code Answers by Language