Thursday, January 12, 2006

Adding Checks after a table has been created

Did you create a table, only to find that you need to add a check constraint?
It happened to me, and I hopped on google to find the code. In this example, we'll use my fictional User table. We want to know if our user is alive or dead. 1 = alive, 0 = dead. Here is the code for SQL server:
alter table dbo.Tbl_User_Table add constraint
CK_User_Alive check (User_Alive in (0,1))
I don't know if it will work with MySql, Oracle, etc, so check your documentation. Happy Coding!