Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Query to find structure of a table

This is a discussion on Query to find structure of a table within the SQL forums, part of the Databases category; Please give me the query.. How to findout the structure of a table? Question asked by visitor Mahesh.Mk...

Geeks Talk > Databases > SQL Query to find structure of a table

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   04-24-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

Query to find structure of a table Please give me the query.. How to findout the structure of a table? Question asked by visitor Mahesh.Mk

The Following 2 Users Say Thank You to Geek_Guest For This Useful Post:

pnrpc2000, yuvarajan2000

Sponsored Links

#2 (permalink)   04-24-2007

yuvarajan2000 Junior Member   Join Date: Apr 2007 Posts: 3 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table desc tablename

#3 (permalink)   04-24-2007

prabhukalai Junior Member   Join Date: Apr 2007 Location: India Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table DESC TABLE_NAME; eg: DESC EMP; EMP is name of table.

#4 (permalink)   04-24-2007

jainbrijesh Moderator   Join Date: Sep 2006 Location: Delhi (India) Posts: 866 Thanks: 12 Thanked 81 Times in 65 Posts

Re: Query to find structure of a table yes Desc Table_name is the query. Desc stands for describe. __________________ Brijesh Jain brijesh.tester@yahoo.co.in http://softwaretestingexpertise.blogspot.com

#5 (permalink)   04-25-2007

sutnarcha Expert Member   Join Date: Nov 2006 Location: Hyd-IND Posts: 523 Thanks: 1 Thanked 55 Times in 46 Posts

Re: Query to find structure of a table All the answers given above are correct. But, as far as I know, DESC /tablename/ is not a query. It is an SQL-Plus command. Because only SELECT statements can be called as a query. __________________ Lack of WILL POWER has caused more failure than lack of INTELLIGENCE or ABILITY. -sutnarcha-

#6 (permalink)   04-25-2007

varmakub Contributing Member   Join Date: Mar 2007 Posts: 43 Thanks: 1 Thanked 2 Times in 2 Posts

Re: Query to find structure of a table Good one from sutnarcha !!! Yes !!! its not a query - Which retrieves some data from the databse :-)

#7 (permalink)   06-01-2007

Cguna Junior Member   Join Date: Apr 2007 Location: Chennai Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table Quote: Originally Posted by Geek_Guest Please give me the query.. How to findout the structure of a table? Question asked by visitor Mahesh.Mk desc Table Name;

#8 (permalink)   06-05-2007

kaarthi_bala Junior Member   Join Date: Dec 2006 Location: salem Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table SQL> desc table_name eg SQL> desc emp or SQL> describe table_name

#9 (permalink)   09-04-2007

yagnam ramesh babu Junior Member   Join Date: Feb 2007 Location: pulivendula,kadapa(district),a.p,india Posts: 7 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table desc

#10 (permalink)   10-23-2007

arunendra kumar Junior Member   Join Date: Oct 2007 Location: delhi Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table desc object_name.

#11 (permalink)   10-23-2007

raj1402 Contributing Member   Join Date: Aug 2007 Posts: 67 Thanks: 9 Thanked 9 Times in 8 Posts

Re: Query to find structure of a table Desc tablename i think its also a query anything getting information is query i quess!!!

#12 (permalink)   09-01-2008

tarikuzzaman Junior Member   Join Date: Sep 2008 Location: Bangladesh Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query to find structure of a table select COLUMN_NAME, DATA_TYPE from USER_TAB_COLUMNS where TABLE _NAME = 'your table name'; .....(Like 'emp')

#13 (permalink)   09-01-2008

Sushma Mosali Expert Member   Join Date: Jun 2007 Location: Australia Posts: 242 Thanks: 6 Thanked 8 Times in 8 Posts

Re: Query to find structure of a table hi, agree with sutnarcha Thanks Sushma

Geeks Talk > Databases > SQL

« Update query using sub query | Sorting columns »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find Table Size	timmy	Oracle	2	09-23-2008 04:52 AM
Structure of Salary	nehalshah	Companies	2	12-07-2007 07:10 AM
Creating a table by copying another table's structure	Allan Paul	Oracle	12	07-12-2007 07:53 AM
How a java table be brought to data table?	dhandhan	QTP	0	04-15-2007 06:14 AM
How to find Defined key fields in a table?	sharifhere	SQL	2	02-22-2007 01:01 AM

All times are GMT -4. The time now is 01:08 AM.