C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Find number of columns in a table

Posted Date: 03 May 2007 Resource Type: Code Snippets Category: SQL Schema

Posted By: Sukanya Member Level: Diamond
Rating:

Points: 10

This is used to find out number of columns in a table


								
select count(*) Noofcolumns from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='table_name')

It will return the number of columns of table.

Responses

Author: Kapil Dhawan 17 Jun 2008 Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.


	Previous Resource: To find the number of columns in a table in sql server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL Schema

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj