General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>If the keys changed quite often, I could see that being a problem. If you were going to use an intelligent key, it's assumed the key would be pretty static. In one of my first systems I ever wrote with VFP (even before MM!) I used intelligent keys. The system is still in production. Recently the client asked me to do some enhancements. I looked at the system and was horrified at some of the code I wrote, but the database design is still pretty solid.
>>
>>Granted, if I had it to do over again, I would use surrogate keys, but just because I used natural keys doesn't make the design bad or invalid.
>
>I agree. I look back at some of the stuff I designed and wrote and wonder what holds it together. < g >
I'm afraid to touch it for fear it may fly apart! <g>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only