name and datatypes of columns in a table

Question

name and datatypes of columns in a table

Atif

Hall of Fame

Points: 3578
More actions
July 28, 2008 at 4:58 am

#124323

AOA
How to get name and data types of columns in a table.
Regards
DBDigger Microsoft Data Platform Consultancy.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

select c.name, t.name from sys.columns c inner join sys.types t on c.user_type_id=t.user_type_id

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

Michael Earl-395764

SSC Guru

Points: 53873

July 28, 2008 at 6:59 am

#849145

or:

sp_Help

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

or:

[font="Courier New"]SELECT

Table_Schema,

Table_Name,

Column_Name,

Data_Type

FROM

information_schema.columns

WHERE

table_name =

AND

table_schema = [schema][/font]

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Atif Hall of Fame Points: 3578 More actions · Answer 4

Thanks for all

DBDigger Microsoft Data Platform Consultancy.