to get description of table

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
to get description of table

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 4th, 2006, 09:17 AM

MunishBhatia MunishBhatia is offline

MunishBhatia is offline

Friend of Wrox

Join Date: Aug 2006

Posts: 231

Thanks: 0

Thanked 1 Time in 1 Post

Default

to get description of table

Hello to All

i want ot know how to get the structure of table by using a query

Plz Tell

thanks......

__________________
thanks......

Old

December 5th, 2006, 06:34 AM

prabodh_mishra prabodh_mishra is offline

prabodh_mishra is offline

Authorized User

Join Date: Sep 2003

Posts: 73

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to prabodh_mishra

Default

sp_help <table name>

Cheers,
Prabodh

Old

December 5th, 2006, 01:26 PM

MunishBhatia MunishBhatia is offline

MunishBhatia is offline

Friend of Wrox

Join Date: Aug 2006

Posts: 231

Thanks: 0

Thanked 1 Time in 1 Post

Default

THanks a lot

thanks......

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
description != '' equivalent	XMLUser	XSLT	3	March 1st, 2008 12:58 PM
Error description from DDQ OnInsertFailure	asharma	SQL Server DTS	0	June 23rd, 2004 11:25 AM
How to display description of default values	Braja Nayak	VS.NET 2002/2003	0	September 8th, 2003 04:43 AM