Re: What columns are in the Primary Key

2001-05-11 Thread Bunyamin K. Karadeniz
VIVOUSER PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

What columns are in the Primary Key

2001-05-10 Thread Helmut Daiminger
PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET

Re: What columns are in the Primary Key

2001-05-10 Thread Lucy Lin
TBACCOUNTS STORELOCID IS NOT NULL VIVOUSER SYS_C003013 C TBACCOUNTS ACCOUNTID IS NOT NULL VIVOUSER PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea

RE: What columns are in the Primary Key

2001-05-10 Thread Paul Baumgartel
TBACCOUNTS STORELOCID IS NOT NULL VIVOUSER SYS_C003013 C TBACCOUNTS ACCOUNTID IS NOT NULL VIVOUSER PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6

Re: What columns are in the Primary Key

2001-05-10 Thread Witold . Iwaniec
TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED

RE: What columns are in the Primary Key

2001-05-10 Thread Jacques Kilchoer
Title: RE: What columns are in the Primary Key -Original Message- From: Helmut Daiminger [mailto:[EMAIL PROTECTED]] Is there a data dictionary view that gives me all the columns in a primary key of a table? Try user_cons_columns. It would probably be of interest to you

RE: What columns are in the Primary Key

2001-05-10 Thread Nicoll, Iain (Calanais)
: Thursday, May 10, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Subject: What columns are in the Primary Key Hi! Is there a data dictionary view that gives me all the columns in a primary key of a table? I can query user_constraints to find out about all constraints on a table