sql query against column names type code example
Example 1: get column name sql server
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'
Example 2: How to View column names of a table in SQL
DESCRIBE Table_Name;
OR
DESC Table_Name;
Example 3: sql query to get column data type in sql
SELECT DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'yourTableName' AND
COLUMN_NAME = 'yourColumnName'