Posted by BillCo on 05/03/07 09:32

I'm coming from a MS Access background and so I'm very used to and
comfortable with the hungarian (Leszynski et al) naming conventions.
However, I'm getting started into my first SQL Server Database and
really want to use the appropriate up to date standard naming
convention (ISO compliant).

I think I have the general idea from raking though countless
conflicting sites and posts, but I'm a bit stuck on what to do
regarding pk / fk naming

For example, in my MS Access world I would have two tables:

tblOrders
=======
strOrderID
intCustomerID
dtOrderDate
....

tblCustomers
==========
intCustomerID
strCustomerName
....


So what would the appropriate and most up-to-date and standard naming
be for SQL Server? My Guess:

Orders
=====
Ord_Order_ID_Pk
Ord_Customer_ID_Fk
Ord_Order_Date
....

Customers
========
Cus_Customer_ID_Pk
Cus_Customer_Name
....

How close (or far) am I from "Celko Proof" naming here?
All help gratefully accepted!

[Back to original message]