Unique Key Syntax

[Sameer]

You are trying to create UNIQUE constraint on column WISP_NAME, but it has duplicate contents.

SELECT * FROM pronto_wisp
WHERE ROWID NOT IN 
( SELECT MIN(ROWID) FROM pronto_wisp GROUP BY wisp_name)

Above sql stmt will give you duplicate records for WISP_NAME. You need to delete duplicate entries prior to creating constraint.

Sameer