Subquery in CHECK constraint - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Subquery in CHECK constraint

Author

Topic

julianfraser
Starting Member

19 Posts

Posted - 2004-07-11 : 10:45:45

I need a work-around for this as SQL Server tells me that you cannot include subqueries in CHECK contraints and I'm not sure of the best way.

ALTER TABLE at_credit_transaction
ADD CONSTRAINT CN_credit_transaction_format
CHECK (transaction_typeID IN
(SELECT transaction_typeID FROM at_transaction_type WHERE transaction_format = 'CRE')
)
GO

Thanks,
Julian.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-07-11 : 12:48:00

you can use a UDF that accepts a transaction_typeID and does the lookup in the table.

- Jeff