Hello Wolfgang, ALTER TABLE <tablename> DROP CONSTRAINT INTEG_485
That should do the trick. Or find the constraint and simply click "Drop" in Database Workbench. ;) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -----Original Message----- From: Wolfgang Kluge [email protected] [firebird-support] Sent: Monday, July 07, 2014 8:22 AM To: [email protected] Subject: [firebird-support] remove constraint Good afternoon. Can anypme give me a hint how I can by code remove a cpnstraiant in a populated database? The constraint type is check and the constraint name is integ_485 regards Wolfgang Kluge ------------------------------------ Posted by: Wolfgang Kluge <[email protected]> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links
