Select Column Information using SQL Server

Why not join our community?, there are 6 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

17
kicks

kick it

Select Column Information using SQL Server

published 1 year, 11 months ago, submitted by fatdaveh 1 year, 11 months ago

geekzilla.co.uk — How to select information about columns in a table using SQL Server.

3 comments | category:

Database | Views: 5 | Get KickIt image code

tags: SQLServer, T-SQL, GeekZilla, SQL | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

fatdaveh - RobChappel -

phayman - goal - marshall -

gavinjoyce - donthop - ashithmr - bgrubbs - jasper22 - Pagem -

marshp3 - bclhaynes - jhol3990 - jeremyh - howardd - rhayman

Comments:

Selecting directly from the system tables is unsupported by Microsoft and is exactly why they created the sp_help stored procedure and it's associates.

[)amien

posted by

DamienG 1 year, 11 months ago

Alternatively SQL 2005 adds metadata support for tables and columns using the syntax:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'Products';

Where Products is the table you want.

[)amien

posted by

DamienG 1 year, 11 months ago

Damien: Wish I had seen INFORMATION_SCHEMA before.

When I get some time I will change the example accordingly

Good info, thanks

posted by fatdaveh 1 year, 11 months ago