Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

The syntax to add a UNIQUE constraint is (done from menu Tools->SQL):

ALTER TABLE "tablename" ADD CONSTRAINT constraintname UNIQUE ("column")

To remove the constraint it is:

ALTER TABLE "tablename" DROP CONSTRAINT constraintname

constraintname is assigned by you. ie: my_constraint Must be unique name in DB.

In the Base query section this statement will list all the table constraints:

 SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS