UMG Developer (9/23/2010)
I agree that OrderRefNo is an identifier, but if you look at my comment I was saying that OrderNo is not an identifier:
OrderNo INT NOT NULL IDENTITY(1,1),
So there aren't multiple identifiers in the table. Given that "Multiple identifier columns" isn't an option for a principle that the DDL violates.
Sorry, UMG. You are right. I saw your comment and interpreted it as defending the "no identifier at all" option - my bad, I should have read better.