Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use Server Date/Time
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01460122
Message ID:
01460181
Vues:
60
>Sometimes I want that, sometimes I don't. I don't see it as a hard and fast rule, which is the way you stated it.
>
>So you design a database "solely" based on what "you" want? <s>
>
>Run this by a DBA....EVERY table should have a way to uniquely identify a single row, and EVERY table needs a timestamp column generated by the server. Period.

I agree completely that you need a way to uniquely identify a row. I *always* use an identity column as the primary key of all of my tables (SQL server is always my data store).

I'm not so sure about a timestamp column on every table. I'd certainly say most tables should have one (especially if the data is user entered - in that case then userID is a requirement also IMHO). Some reference tables just don't have that need IMO.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform