Wha tis the syntax from dropping a required constraint using SQL?

Robert

If the constraint is created using a UNIQUE index you would use the statement:

DROP INDEX(TableName."IndexName") ;

If the constraint were the result of a condition created on an individual column you would
use REDEFINE for that column

i.e.

ALTER TABLE "TableName"
REDEFINE COLUMN "FieldName" [FieldType] ;

Simply not including the existing constraint in the REDEFINE would equate to it being
"dropped" from the columns definition.

--

At least this works for me in V3 (just about to update to V4!)

Adam