integer id columns for all tables

Someone with greater expertise than I recently told me that it is best to have an integer primary-key for all tables in a database, even if the table already has some non-integer primary key, or some sort of composite primary key. If there is already a non-integer key, then create a new sequence column and set that as the primary key.

Does anyone have an opinion on this and why? Received on Fri Aug 25 2006 - 16:33:44 CEST