table design

Question

Post reply

table design

Mike Levan

SSChampion

Points: 14201
More actions
October 17, 2007 at 11:30 am

#61390

How can I enforce a constraint on a field in a table so that it allows only the value " CAT"

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

Just curious, but if every entry is going to have the same value, why are you storing it at all?:hehe:

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Mike Levan SSChampion Points: 14201 More actions · Answer 2

I want to do this only for the future entries, the existing data shud not change

mrpolecat SSCertifiable Points: 7014 More actions · Answer 3

you could put an insert trigger that sets it to "CAT" and an update trigger that disallows the update if it is set to "CAT" assuming that this is the rule that you are trying to enforce.

Ronald San Juan SSCrazy Points: 2937 More actions · Answer 4

create a CHECK CONSTRAINT...

Ronald San Juan | SQL DBA
ID 710124 ~ Code "Northwind"

Mike Levan SSChampion Points: 14201 More actions · Answer 5

I think

we can add a constraint for that field with expression columnname='CAT' and un check the box where it has " check for existing data"

how is tht?