> > If your client/boss tells you that
> > the next update of WardrobeManager.exe should allow multiple shirts,
> > you will need to do a lot of changes on your DB to allow it, if you
> > used a generated key that has no business meaning, the change will be
> > a lot easier
>
> A lot of changes?
>
> Drop PK & create index is the whole change.
Unless you use that 'old' PK in any stored procedures, SQL in your app etc,
which is common.
Phil
--
Linux 2.4.4-4GB
1:57pm up 7 days, 20:23, 1 user, load average: 0.39, 0.27, 0.16