To remove a constraint in code where I don't know the name
of the constraint, I use this syntax:
SET VAR vTableID = sys_table_id from sys_tables where sys_table_name = 'Loads'
SET VAR vIndexName = sys_index_name from sys_indexes where sys_table_id = .vTableID AND +
Sys_column_name = 'Loadware'
ALTER TABLE loads DROP CONSTRAINT &vIndexName
Karen
