Re: How do I view the key contraints on Oracle7??

In article <Roberts_Daniel_g.PRILVMS3-1505951146430001_at_riversend.bms.com>, Dan Roberts <Roberts_Daniel_g.PRILVMS3_at_msmail.bms.com> wrote:
>
>key constriants..how do I view them to make sure I did it correctly??
>The describe table command jsut shows me attribute names and such
>and I just can't figure out how to view the key constraints.>thnaks for your
>hgelp.>>dan
>--
>Dan Roberts
>BRISTOL-MYERS SQUIBB PHARM. RES. CENTER "Nature is last at Bats"
>PRINCETON, NEW JERSEY U.S.A. PLANET EARTH, MILKY-WAY GALAXY
><<<<INTERNET ADDRESS>>>>Roberts_Daniel_G.PriLVMS3_at_MSMAIL.BMS.COM

The system user who is the dba has a table called dba_constraints. This table contains information about constraints. Depending on you role setup you can run the follwing query. select constraint_name,constraint_type from dba_constraints where table_name='&tname';
Runnning this as system would definitely work. This should give you the constraints.
Hope this helps.
Mahesh Vallampati

Thanks
Mahesh Vallampati

Home:				   Office:
PH : 409 846 3794 (H)		|  409 862 1070 (O)
e-mail address  : vallampa_at_ee.tamu.edu
WWW 		: http://tam2000.tamu.edu/~m0v5533/
Lab 		: 409 847 8609