Select Column Information using SQL Server

home
database
view story

17 Kicks

Kick It

Drop Kick

Kicked

Select Column Information using SQL Server (geekzilla.co.uk)

submitted by fatdaveh(1420) 5 years, 8 months ago

How to select information about columns in a table using SQL Server.

3 comments |category: Database |Views: 28
Tweet

tags: T-SQL GeekZilla SQL SQLServer another

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:

rhayman(0) -

Pagem(360) -

jeremyh(0) -

jhol3990(495)

More who kicked this story...

Comments:

posted by DamienG(1405) 5 years, 8 months ago 0

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(1405) 5 years, 8 months ago 0

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 fatdaveh(1420) 5 years, 8 months ago 0

Damien: Wish I had seen INFORMATION_SCHEMA before.

When I get some time I will change the example accordingly

Good info, thanks

Most Active Users

What's this?