I see how to do this if it is a "dcleared" constraint, but this was just defined in the table createion as inL report_no varchar UNIQUE , -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin