Roja-Sql Server
Home
ASP.NET
VB.NET
C#
JQuery
SQL
Interview Questions
Find me on Facebook
Find me on Twitter
how to get the column names and corresponding datatypes in particular table using SQL Server
SELECT
column_name
'Column Name'
,
data_type
'Data Type'
,
character_maximum_length
'Maximum Length'
FROM
information_schema
.
columns
WHERE
table_name
=
'Country'
Newer Post
Older Post
Home