Mike Yearwood
Toronto, Ontario, Canada
Environment versions
Network:
Windows 2003 Server
Unfortunately, there are no standards. What I try to insist on is to make every field name unique in the entire database. I say try because I'm often too tired to argue the point. ;)
I follow Drew Speedie's style which uses a 3 char prefix followed by an underscore and the field name. I don't see the underscore as really necessary. Inv_CusFK is the customer foreign key in the invoice table. Cus_PK is only from the customer table and inv_pk is only from the invoice table.
>Does anyone have a link or recommendations on standard naming conventions for SQL server tables, fields etc?
>
>I have seen plenty of recommendations but everyone seems to have a different take on it. I guess I am looking for some "industry standard" conventions (if there are any.)
Previous
Next
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