Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Naming Primary Key Indexes

Naming Primary Key Indexes

From: <stuco_at_mailcity.com>
Date: Thu, 18 Jun 1998 19:19:47 GMT
Message-ID: <6mbp8i$c7r$1@nnrp1.dejanews.com>


I am using DDL in a way that creates primary keys in ths same 'CREATE TABLE' statement. I can designate a specific tablespace for that index, however, I am having trouble giving that index a meaningful name!

I know I can create the table then create a primary key index with a name, but that's real ANNOYING to me.

I also know that I can mess around with the sys.obj$ view to rename those cryptic indexes, but (YIKES) that seems to scary!

Is there a way to give primary key indexes a NAME in the same statement as 'CREATE TABLE'???? If not, do I risk being annoyed out of my gourd, or risk getting fired (hmmmm...let's really think about that one! :) ).

Thank you, Oh Great Community of Oracle Experts!!

Stuart L. Cowen
Paladin Consulting - Dallas

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 18 1998 - 14:19:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US