--建表
use bbsDB
Go
if exists(select * from sysObjects where name='bbsUsers')
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null, --用户密码
Uemail varchar(20), --电子邮箱
Usex bit not null, --性别
Uclass int, --等级
Ustatement varchar(20), --备注
UregDate datetime not null, --注册日期
Ustate int, --用户状态
Upoint int, --用户积分 constraint PK_UID primary key(UID),
constraint DF_Upassword default ('888888') for Upassword,
constraint DF_Usex default (1) for Usex,
constraint DF_Uclass default(1) for Uclass,
constraint DF_UregDate default (getDate()) for UregDate,
constraint DF_Ustate default (0) for Ustate,
constraint DF_Upoint default (20) for Upoint,
constraint CK_Uemail check (Uemail like '%@%'),
constraint CK_Upassword check (len(password)>=6)
)
use bbsDB
Go
if exists(select * from sysObjects where name='bbsUsers')
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null, --用户密码
Uemail varchar(20), --电子邮箱
Usex bit not null, --性别
Uclass int, --等级
Ustatement varchar(20), --备注
UregDate datetime not null, --注册日期
Ustate int, --用户状态
Upoint int, --用户积分 constraint PK_UID primary key(UID),
constraint DF_Upassword default ('888888') for Upassword,
constraint DF_Usex default (1) for Usex,
constraint DF_Uclass default(1) for Uclass,
constraint DF_UregDate default (getDate()) for UregDate,
constraint DF_Ustate default (0) for Ustate,
constraint DF_Upoint default (20) for Upoint,
constraint CK_Uemail check (Uemail like '%@%'),
constraint CK_Upassword check (len(password)>=6)
)
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null, --用户密码
Uemail varchar(20), --电子邮箱
Usex bit not null, --性别
Uclass int, --等级
Ustatement varchar(20), --备注
UregDate datetime not null, --注册日期
Ustate int, --用户状态
Upoint int, --用户积分constraint PK_UID primary key(UID),
constraint CK_Uemail check (Uemail like '%@%'),
constraint CK_Upassword check (len(upassword)>=6)
)alter table bbsUsers add constraint DF_Upassword default ('888888') for Upassword
alter table bbsUsers add constraint DF_Usex default (1) for Usex
alter table bbsUsers add constraint DF_Uclass default(1) for Uclass
alter table bbsUsers add constraint DF_UregDate default (getDate()) for UregDate
alter table bbsUsers add constraint DF_Ustate default (0) for Ustate
alter table bbsUsers add constraint DF_Upoint default (20) for Upoint
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null primary key, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null default ('888888') check (len(Upassword)>=6), --用户密码
Uemail varchar(20) check (Uemail like '%@%'), --电子邮箱
Usex bit not null default(1), --性别
Uclass int default(1), --等级
Ustatement varchar(20), --备注
UregDate datetime not null default getDate(), --注册日期
Ustate int default (0) , --用户状态
Upoint int default (20) --用户积分
)
use bbsDB
Go
if exists(select * from sysObjects where name='bbsUsers')
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null, --用户密码
Uemail varchar(20), --电子邮箱
Usex bit not null, --性别
Uclass int, --等级
Ustatement varchar(20), --备注
UregDate datetime not null, --注册日期
Ustate int, --用户状态
Upoint int, --用户积分constraint PK_UID primary key(UID),
constraint DF_Upassword default ('888888') for Upassword,
constraint DF_Usex default (1) for Usex,
constraint DF_Uclass default(1) for Uclass,
constraint DF_UregDate default (getDate()) for UregDate,
constraint DF_Ustate default (0) for Ustate,
constraint DF_Upoint default (20) for Upoint,
constraint CK_Uemail check (Uemail like '%@%'),
constraint CK_Upassword check (len(password)>=6)
)
use bbsDB
Go
if exists(select * from sysObjects where name='bbsUsers')
drop table bbsUsers
Go
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null, --标识列,自动增长
Uname varchar(15) not null, --用户名
Upassword varchar(10) not null, --用户密码
Uemail varchar(20), --电子邮箱
Usex bit not null, --性别
Uclass int, --等级
Ustatement varchar(20), --备注
UregDate datetime not null, --注册日期
Ustate int, --用户状态
Upoint int, --用户积分constraint PK_UID primary key(UID),
constraint DF_Upassword default ('888888') for Upassword,
constraint DF_Usex default (1) for Usex,
constraint DF_Uclass default(1) for Uclass,
constraint DF_UregDate default (getDate()) for UregDate,
constraint DF_Ustate default (0) for Ustate,
constraint DF_Upoint default (20) for Upoint,
constraint CK_Uemail check (Uemail like '%@%'),
constraint CK_Upassword check (len(password)>=6)
)
字段 字段类型 约束类型 约束名
或
alter table tablename add constraint 约束类型 约束名