Hello Wolfgang,

ALTER TABLE <tablename> DROP CONSTRAINT INTEG_485

This works nicely.

regards
Wolfgang Kluge

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 wkluge@... [firebird-support]
Sent: Monday, July 07, 2014 8:22 AM
To: firebird-support@yahoogroups.com
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 <wkluge@...>
------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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