Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Constraints attached to a table
Mukut wrote:
> I need to find all the constraints defined at table level as well as
> column level for a table.What would be the right approach to find those
> constraints?
>
Well, you can select required data from the USER_CONSTRAINTS table. If you have chance to use some gui tool (like TOAD), you would just click on the 'constraints' tab. Does this help? Received on Tue Jul 25 2006 - 01:34:57 CDT