: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:23 AM
To: CF-Talk
Subject: RE: DB Table Naming Conventions
MS says that only system stored procedures should start with sp becasue
when sql recieves a stored proc with sp_ it looks in the master system
stored procedures first
proc_procedureName
Matt
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:32 AM
To: CF-Talk
Subject: RE: DB Table Naming Conventions
Really? Wow ... I didn't know that. How do you prefix or designate
Stored Proceedures?
Joshua
proc_
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:32 AM
To: CF-Talk
Subject: RE: DB Table Naming Conventions
Really? Wow ... I didn't know that. How do you prefix or designate
Stored Proceedures?
Joshua Miller
Web Development
Lol, same answer, same time.
Matt
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:44 AM
To: CF-Talk
Subject: RE: DB Table Naming Conventions
proc_
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent
or xyz_chkUserLogin
Joe
- Original Message -
From: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 11:51 AM
Subject: RE: DB Table Naming Conventions
Lol, same answer, same time.
Matt
-Original Message-
From: Joshua
I'm just curious, What naming conventions for DB tables do you
use?
BJ
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| I'm just curious, What naming conventions for DB tables do you
| use?
this is a biggy :-) a lot of php developers that work with mysql, a non
relational db use pk names of ID
I always name the pk of table
| From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
|
| I always name the pk of table (table_name)_id... I also
| tend to prefix ~ column names with an abbreviation of the
| table name, it makes life easier as there is more
| information there and when you start joining tables, there
| is less
what about naming the actual tables? Do you have naming conventions
for lookup tables, many to many relationship tables, data storage
tables, ect?
I have seen people put a 'tbl' prefix to every table and an 'sp'
prefix to all stored procedures... what else?
BJ
= = = Original message = = =
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:20 AM
To: CF-Talk
Subject: Re: DB Table Naming Conventions
-BEGIN PGP SIGNED MESSAGE
(Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:20 AM
To: CF-Talk
Subject: Re: DB Table Naming Conventions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED
Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:20 AM
To: CF-Talk
Subject: Re: DB Table Naming Conventions
-BEGIN PGP SIGNED
:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:50 AM
To: CF-Talk
Subject: RE: DB Table Naming Conventions
what about naming the actual tables? Do you have naming conventions
for lookup tables, many to many relationship tables, data storage
tables, ect?
I have seen people put a 'tbl' prefix
13 matches
Mail list logo