Limiting Values

  • Do this with a check constraint. Ex.

    ALTER TABLE tableX WITH NOCHECK

    ADD CONSTRAINT limitvalue CHECK (columnx IN ('A','I','U')

    If you want to have check table at creation chnage NOCHECK to CHECK

    See BOL for more help.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing post 1 (of 2 total)

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