Home » RDBMS Server » Server Administration » check constraint
check constraint [message #374587] Wed, 20 June 2001 06:47
Bonnie Melanson
Messages: 3
Registered: April 2001
Junior Member
I have a check constraint as follows:

check (column_name in ('Y',null))

I only want to allow either null or 'Y' entries, however the database will allow ANY entry. How do I allow only a 'Y' or a null value?????

Thanks!

Report message to a moderator

Previous Topic: Query
Next Topic: Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 16:02:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.