|
|
Posted by Hugo Kornelis on 11/01/05 00:52
On 31 Oct 2005 14:42:28 -0800, Dave wrote:
>Can you create a unique constraint on multiple columns, or does it have
>to be implemented as a unique index?
>
>If possible can someone please post some sample code?
>
>Thanks,
Hi Dave,
CREATE TABLE Example
(Col1 int NOT NULL,
Col2 int NOT NULL,
UNIQUE (Col1, Col2)
)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|