Community

Finding primary keys and missing primary keys in SQL Server

(Greg Robidoux) One design aspect that all tables should have is a primary key. The primary key is the main entry way into your dataset, so that when you access your data you are guaranteed to only affect one row of data.