Base.(H)SQL How to remove a constraint?

Wolfgang Schaible <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Organization atHome
Message-ID <[email protected]>
hi,
the HSQL Syntax says: 
ALTER TABLE <tableName> DROP CONSTRAINT <constraintName>

I saw in file database/script the create statement with
... CONSTRAINT SYS_CT_118 UNIQUE("RID")
and use the 'SYS_CT_118' as name in the sub rmConstraint

The sub complains with: Constraint not found...

sub rmConstraint
  Dim sCmd as string
  if(Not initEnv())then	exit Sub		'makes connection
  sCmd ="ALTER TABLE ""JM_L26B_04"" DROP CONSTRAINT ""SYS_CT_118"" "
  oStmt.executeUpdate(sCmd )
end sub 'rmConstraint

Any idea?

Kind regards,
Wolfgang
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.