At 02:07 PM 9/17/2013, Bruce A. Chitiea wrote:
The Command Index syntax diagram for ALTER TABLE contains this construct:
ALTER TABLE tblname DROP CONSTRAINT conname
Maybe I'm just blanking, but what class of constraints is user-namable?
What would be a strong working example of a 'conname'?
Bruce,
FWIW ...
Using the syntax above to DROP the constraint, you MUST know the ID Number.
Use "LIST CONSTRAINTS" command to first find the ID and then use the syntax
as you see fit.
Keep in mind that you cannot DROP any constraint(s) that is REFERENCED.
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
