Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL query
You can use USER,ALL or DBA view to find the constraints...
--table constraints
select constraint_name, constraint_type
from user_constraints
where table_name = '&table_name'
/
--table column constraints
select column_name,position
from user_cons_columns
where table_name = '&table_name'
and constraint_name = '&constraint_name'
/
-----Original Message-----
Sent: Saturday, July 13, 2002 2:53 AM
To: Multiple recipients of list ORACLE-L
I am using an Oracle database running in Linux. I would like to view the description of a table. For ex., if there is a table called 'person'. I would like to see the names of the columns in this table, their datatypes and such other details. In other dbmss like mysql a command 'describe <tablename>' gives the information. What is the equivalent in Oracle?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vandana
INET: vandana_at_gdit.iiit.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Huntley
INET: rhuntley_at_mindleaders.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 15 2002 - 09:28:26 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |