Perfect. Thanks, Razzak
Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, September 17, 2013 11:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ALTER TABLE Question 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! --
