Creating a PK via Create Unique Index plus key OR via PK constrain only
119642Sep 16 2008 — edited Sep 16 2008What is the "importance" of the following difference :-
Some of the PK indexes in the database I look after are scripted by creating a Unique index first and then adding the PK constraint with the syntax "using index"
Others just create the PK using the add primary key constraint syntax.
Is one way better than the other or where in the documentation would this be discussed? I can't find it discussed most probably looking in the wrong book.
Thanks in advance. Bill