select object_name from all_objects where lower(object_name) like '%cons%';
will give you all the data dictionary tables/views that deals with constraints ltiu On Saturday 13 July 2002 01:08, Vandana wrote: > I am sorry for not being precise in my question. I would like to > view the primary key, foreign key and other 'constraints' information of > my table. While this could be viewed with 'desc' in other dbmss, this > information is not provided with the 'desc' in oracle. With what command > can I view it in Oracle? > > On Fri, 12 Jul 2002, Abdul Aleem wrote: > > At SQL*Plus it is the same command > > Describe or desc and name of the table > > > > You also need to be connected to the database > > > > HTH > > Aleem > > -----Original Message----- > > Sent: Saturday, July 13, 2002 11:53 AM > > To: Multiple recipients of list ORACLE-L > > Subject: SQL query > > > > > > 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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
