Here I will explain how to get the column names and corresponding datatypes in particular table using SQL Server.
I have one table with lot columns in database at that time I tried to know the column names and corresponding datatypes and their maximum sizes in particular table for that I written the following query in SQL server to get column names and datatypes in particular table.
SELECT column_name 'Column Name',
data_type 'Data Type',
character_maximum_length 'Maximum Length'
WHERE table_name = 'Country'
This is the demo
Read more: Christian D. Yellington