You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by Rosey Edwards <ro...@cfl.rr.com> on 2009/05/23 02:35:03 UTC

Check Constraints

Hello,

Does the Torque schema allow check constraints to be specified such as the one in the following create table statement?
Can any check constraint be specified?

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')
)

Thanks.

Antwort: Check Constraints

Posted by Thomas Fischer <fi...@seitenbau.net>.

No, this is not implemented.

For such features, I'd use the automatically generated sql and run a custom
sql script containing "alter table..." scripts on top.

   Thomas



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org