Another important art is choosing a good, unique primary key for every table. ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple.