Create Unique Index

[Warren Kuhl]

I have a table called table1 and want to create a unique index (called
index1) with the fields - field1 and field2.  What is the snytax?

I am trying:

CREATE [UNIQUE] INDEX index1 ON table1 (field1,field2)

I get the error:

11:24:19 AM Kernel error: 0x71000. line 1:15: expecting "database", found
'UNIQUE'

Thanks,
Warren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20101121/d58f252c/attachment.htm>