db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rosey Edwards" <roseyedwa...@cfl.rr.com>
Subject Check Constraints
Date Sat, 23 May 2009 00:35:03 GMT
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.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message