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 !

How to find out a particular Column in SQL Server

Posted Date: 09 Mar 2008 Resource Type: Code Snippets Category: SQL

Posted By: @@@ Hyderabadi Biryani @@@ Member Level: Diamond
Rating:

Points: 10

How to find out a particular Column and its details from all the columns in SQL Server

								

select sysobjects.name as 'TableName', * from syscolumns, sysobjects
where syscolumns.name='columnname'
and sysobjects.id = syscolumns.id
and (sysobjects.xtype='U' or sysobjects.xtype='S')

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

Author: Apurba Kumar Sarkar 24 Jun 2008 Member Level: Bronze Points : 1

Use "Database Name"

Select * From INFORMATION_SCHEMA.COLUMNS
Where column_name = "Column Name"

Author: ravi 25 Jun 2008 Member Level: Gold Points : 0

hmmm useful code

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.

	Next Resource: How to return the current lock time-out setting in milliseconds for the current session.
	Previous Resource: Find all store procedure and table details
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

efax