Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Tables vs SQL Server
Message
From
24/01/2000 08:29:38
 
 
To
24/01/2000 00:17:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00321142
Message ID:
00321594
Views:
35
>
>Right, thats what I said I use, only it would be:
>
>id_cust
>
>Why the under score? Lets do an experiment, barley glancing through, tell me how many PKs or FKs (like you and I agree, the fieldname will flow through all the tables) are in this list:
>
>GSDFG
>SDFG
>OIYID
>HGHW
>GIUIUID
>JHGJQID
>WQQVB
>DVBSWQ
>YUYJN
>FGJID

>
>Now how many in mine:
>
>GSDFG
>SDFG
>ID_OIY
>HGHW
>ID_GIUIU
>ID_JHGJQ
>WQQVB
>DVBSWQ
>YUYJN
>ID_FGJ

>
>While the ability to point out ID fields in gibberish isn't much of an advantage, I think it doesn't hurt.

Again...this is a personal preference.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform