Check Constraints
"Rosey Edwards" <[email protected]> Fri, 22 May 2009 20:35:03 -0400
| Newsgroups | gmane.comp.jakarta.turbine.torque.user |
|---|---|
| Message-ID | <AD0201B376544C0E820473B40ACD5F8C@ebel599d8c8e1b> |
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.