Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: describe table
Hi
You can use USER_IND_COLUMNS. Use USER_CONSTRAINTS to identify the primary key index.
Alistair
"Peter Valicek" <Sonny2_at_gmx.de> wrote in message news:b454q8$4d8$04$1_at_news.t-online.com... Hello,
how can I get the infos from a table abput which field is an index and where is the primary key. I'd like to know this to improve my sql queries.
Thanks in forward.
-Peter Received on Wed Mar 05 2003 - 10:28:18 CST