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.)