Jim Smith wrote:
Wasn't my question.
well ... it was mine but I'll share it with you ;)
Why do you need to label a table as a table?
That was my thought, too.
There is some merit in using
type prefixes in VB because of its loose typing, but it makes no sense in a
database context where the t
TED]>
Date: Friday, August 1, 2003 10:39 am
Subject: RE: RE: standardized naming system ?
> Wasn't my question.
>
> Why do you need to label a table as a table? There is some merit
> in using
> type prefixes in VB because of its loose typing, but it makes no
> sense
tuno KOVICK [mailto:[EMAIL PROTECTED]
> Sent: 01 August 2003 15:24
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: RE: standardized naming system ?
>
>
> Jim,
>
> Great question!
>
> I use the ol'Reddick VBA naming conventions.
>
> tbl - table
TECTED]>
Date: Friday, August 1, 2003 10:03 am
Subject: RE: standardized naming system ?
> >
> > Hello list,
> >
> > is there a common naming system for db objects ?
>
> Thousands.
>
> > Like:
> >
> > 1) Tables: mytable, tblmytable, tbl_mytable
>
> Hello list,
>
> is there a common naming system for db objects ?
Thousands.
> Like:
>
> 1) Tables: mytable, tblmytable, tbl_mytable
>
> 2) Indices: idx_anindex
>
> 3) Columns: int_somenumber, date_lastupdate
>
> 4) id for the numerical primary key e.g. table customers.id
> and then fo
ment is for. ;)
-Rob
-Original Message-
From: Andreas [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:34 AM
To: [EMAIL PROTECTED]
Subject: standardized naming system ?
Hello list,
is there a common naming system for db objects ?
Like:
1) Tables: mytable, tblmytable, tbl
Hello list,
is there a common naming system for db objects ?
Like:
1) Tables: mytable, tblmytable, tbl_mytable
2) Indices: idx_anindex
3) Columns: int_somenumber, date_lastupdate
4) id for the numerical primary key e.g. table customers.id
and then for referencing foreign keys
table