Using SQL Server to Get the Column Names and Corresponding Datatypes in Particular Table

Here I will explain how to get the column names and corresponding datatypes in particular table using SQL Server.

Description:

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.

USE MySampleDB 

GO

SELECT column_name 'Column Name',

data_type 'Data Type',

character_maximum_length 'Maximum Length'

FROM information_schema.columns

WHERE table_name = 'Country'

This is the demo

Read more: Christian D. Yellington

QR: 

Posted via email from Jasper-net