create table UserInfo(
ID int identity (1,1) primary key not null ,//设置标识列,主键
Name varchar(20) not null,
Age int not null,
Sex int not null,
CreateTime datetime default getDate() not null //设置默认值为当前时间
)
ID int identity (1,1) primary key not null ,//设置标识列,主键
Name varchar(20) not null,
Age int not null,
Sex int not null,
CreateTime datetime default getDate() not null //设置默认值为当前时间
)