黑马程序员--给表添加约束

---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流！ ----------------------

--给表添加约束
alter table cardinfo
add constraint pk_cardid primary key(cardid)
alter table cardinfo
add constraint ck_cardid check(cardid like '1010 3576[0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
alter table cardinfo
add constraint df_curtype default 'RMB' FOR curtype
alter table cardinfo
add constraint ck_svaetype check(savingtype='定期' or savingtype='活期' or savingtype='定活两便')
alter table cardinfo
add constraint df_opendate default getdate() for opendate
alter table cardinfo
add constraint ck_openmoney check(openmoney>=1)
alter table cardinfo
add constraint ck_balance check(balance >=1)
alter table cardinfo
add constraint df_pass default '888888' for pass,constraint ck_pass check(pass like '[1-9][0-9][0-9][0-9][0-9][0-9]')
alter table cardinfo
add constraint df_IsReportLoss default 0 for IsReportLoss
alter table cardinfo
add constraint fk_customerID foreign key(customerid) references userinfo(customerid)
go

---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流！ ----------------------