黑馬程式員--給表添加限制

---------------------- 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教育訓練、期待與您交流！ ----------------------