Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Naming Primary Key Indexes
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