SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to name the primary key of a table?

 

This is a hotly debated issue in database design and modelling.

There are 2 ways:

1. ID

The advantage of this that in a join you can tell which is the primary key.

2. TableXID

This has the advantage of satisfying tools which are doing automatic matching of primary keys and foreign keys.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page