Sql - What is the use of DESC in SQL?

radhika_btech · 23-01-07, 09:29 PM

**sk_kireeti** · 26-01-07, 06:10 PM

DESC or DESCRIBE gives database structural information of the object.

ajithcharles · 26-01-07, 06:45 PM

i think its a duplicate post i remember answering this before .. krishna can u point it to that post and close it

**sk_kireeti** · 28-01-07, 12:02 AM

Thanks for pointing out Ajith. The other post is in "My SQL" section. Here is the link for it. Not sure if "My SQL" also has same commend. So not sure whether to keep it or delete it.

desc

Thanks,
Krishna

pradeepmca23 · 20-03-08, 11:59 PM

desc is used to know list of tables object in database .Ex:- select*from cat: using this coomand then can u clearlu known .

23-01-07, 09:29 PM	#1 (permalink)
radhika_btech Senior Member Join Date: Jan 2007 Age: 27 Posts: 283 Thanks: 0 Thanked 2 Times in 2 Posts Thanks: 0 Thanked 2 Times in 2 Posts Rep Power: 4	Sql - What is the use of DESC in SQL? Sql - What is the use of DESC in SQL?

26-01-07, 06:10 PM	#2 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Location: Hyderabad Posts: 2,355 Thanks: 117 Thanked 241 Times in 198 Posts Thanks: 117 Thanked 241 Times in 198 Posts Blog Entries: 4 Rep Power: 51	Re: Sql - What is the use of DESC in SQL? DESC or DESCRIBE gives database structural information of the object. __________________ Give 1 cup rice to a hungry Indian just by a mouse click. No money, no form filling, no hassle... Click here for the donation.

26-01-07, 06:45 PM	#3 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: Sql - What is the use of DESC in SQL? i think its a duplicate post i remember answering this before .. krishna can u point it to that post and close it __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

28-01-07, 12:02 AM	#4 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Location: Hyderabad Posts: 2,355 Thanks: 117 Thanked 241 Times in 198 Posts Thanks: 117 Thanked 241 Times in 198 Posts Blog Entries: 4 Rep Power: 51	Re: Sql - What is the use of DESC in SQL? Thanks for pointing out Ajith. The other post is in "My SQL" section. Here is the link for it. Not sure if "My SQL" also has same commend. So not sure whether to keep it or delete it. desc Thanks, Krishna __________________ Give 1 cup rice to a hungry Indian just by a mouse click. No money, no form filling, no hassle... Click here for the donation.

20-03-08, 11:59 PM	#5 (permalink)
pradeepmca23 Junior Member Join Date: Mar 2008 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: Sql - What is the use of DESC in SQL? desc is used to know list of tables object in database .Ex:- select*from cat: using this coomand then can u clearlu known .

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Server 2005 Books Online (July 2006)	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	2	11-07-08 03:01 AM
Microsoft SQL Server Tips	LALIT KUMAR	VB / ASP.NET Technologies	0	22-12-06 04:19 PM
Ramco Systems Hiring SQL Developers	sridhar	EXPERIENCED JOBS	0	02-12-06 01:46 PM
Position Vacant SQL DBA (2 - 4 YRS EXP) - URGENT	sridhar	EXPERIENCED JOBS	0	24-10-06 01:55 AM
hi.....	gomesh_2k6	VB / ASP.NET Technologies	8	07-09-06 01:38 PM