Re: Primary Key on Column ?

From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/11/26
Message-ID: <49apl5$lbi$1_at_mhafn.production.compuserve.com>#1/1

At table level, the key can comprise more than one column. For example an item may have a key of contract number, item number, and so should be defined at table level. The contract would have the key contract no which could be set at either column or table level. A single column primary key is normally faster, but I don't think it makes any difference if its done at table or column level. I'd define all keys at the table level for consistency purposes. Gary

-- 
Gary Myers, Analyst/Programmer, Kaisha Technology, West of England

Received on Sun Nov 26 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Jan Pehrson: "Convert from Microsoft Access database to PO7"
Previous message: Yoo-Shin Lee: "outer joins"
Next in thread: Randy Dewoolfson: "Re: Primary Key on Column ?"
Reply: Randy Dewoolfson: "Re: Primary Key on Column ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message