Re: Column Questions

On Mon, 28 May 2001 22:36:19 +1000, "Howard J. Rogers"
<howardjr_at_www.com> wrote:

>Trouble starts, though, with concatenated constraints and indexes, since an

Yes, the best plans of man and mice can go astray... ;-)

My standard nowadays for PK/UK/FK is:

<table_name>_PK
<table_name>_UK<sequential number>
<table_name>_<related table_name>_FK

For other indexes:

<table_name>_ID<sequential number>

I can always get the names of the columns from looking at dba_ind_columns or dba_constraints/dba_cons_columns with a couple of general purpose scripts. If there is a problem with indexing strategy I'll have to do it anyway, why bother sticking columns in the name of the index? Much more interested in knowing at a glance if the index is a PK, UK, FK or custom.

Works for me.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Mon May 28 2001 - 07:49:01 CDT