alter table <表1>
add const pk_uid primary key(uid), --主键约束
alter table ...
add const df_address default('地址不详')for address, --默认约束
alter talbe ...
add const ck_sex check(sex in('男,女')),
alter talbe ...
add const ck_sex check(sex ='男' or sex ='女'),
alter table ...
add const ck_age check(age between 12 and 30), --检查约束
alter table ...
add const uq_number unique(number) --唯一约束
alter table ...
add const ck_num check(num like '[1][2] [4][_] [0-9][0-9] [0-9][a-z]'), --检查约束
alter table ...
add const ck_lenght check(len(lenght)>6), --检查约束长度大于6
alter table ...
add const ck_number ckeck(number>1), --检查这个数大于 1 const df_time default(datatim()) for time本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/Sillyman02/archive/2009/08/19/4464416.aspx
add const pk_uid primary key(uid), --主键约束
alter table ...
add const df_address default('地址不详')for address, --默认约束
alter talbe ...
add const ck_sex check(sex in('男,女')),
alter talbe ...
add const ck_sex check(sex ='男' or sex ='女'),
alter table ...
add const ck_age check(age between 12 and 30), --检查约束
alter table ...
add const uq_number unique(number) --唯一约束
alter table ...
add const ck_num check(num like '[1][2] [4][_] [0-9][0-9] [0-9][a-z]'), --检查约束
alter table ...
add const ck_lenght check(len(lenght)>6), --检查约束长度大于6
alter table ...
add const ck_number ckeck(number>1), --检查这个数大于 1 const df_time default(datatim()) for time本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/Sillyman02/archive/2009/08/19/4464416.aspx
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货