Naming Primary Key

From: Stan <delphidev_at_yahoo.com>
Date: Wed, 03 Mar 1999 15:40:29 -0500
Message-ID: <36DD9E3D.8C474C5@yahoo.com>

Is there a way that you can assign a name to the primary key the same way you can an index?

If I do:
alter table person add primary key(ssn); create index lastname on person(lname); select index_name from user_indexes;

Produces:

INDEX_NAME

---

LASTNAME
SYS_C00497 How could I change "SYS_C00497" to something more descriptive.

Thanks, Stan. Received on Wed Mar 03 1999 - 14:40:29 CST