Congratulations to all the winners of April 2013, they have won INR 3400 cash and INR 20147 worth prizes !

Home Freshers Career Advice Articles Interviews Videos Forums Codes Blogs Jobs ASP.NET MVC Community Jokes Chat

Online : 4020 | Welcome, Guest! Register Login

Home > Code Snippets > SQL Server > Finding the Columns information of a table in SQL. ...

FREE video tutorials

Winners

Winners & Prizes

Announcements

Like us on Facebook

Top Codes Authors

Sat, 18-May-2013 Authors

All Time Authors

7960

6200

5800

Latest members | More ...

(Statistics delayed by 5 minutes)

Finding the Columns information of a table in SQL.

Submit Code |

Search Codes |

Code Home |

Its a simple SQL statement,
Which is :

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

Best Regards,
Puneet Sharma - Infosys
Pune, India

Found interesting? Add this to:

| More | Bookmark It

>> Write Response - Respond to this post and get points

More codes snippets
	Bulk Copy from Dot Net to SQL Table Add comment to table in Oracle INTERVAL YEAR to MONTH datatype in Oracle TTITLE and BTITLE commands SET command in Oracle && Substitution variable in Oracle & Substitution variable in Oracle Decode function in Oracle MONTHS_BETWEEN - date function in Oracle Submit Code \| More ...

General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/18/2013 12:09:33 PM

Finding the Columns information of a table in SQL.

More codes snippets