创建表

//自增加主键
create table PLUS_SMS
(
    s_id int IDENTITY(1,1) Primary Key,
    beginTime DateTime not null,
    endTime DateTime not null,
    senderCode varchar(20) not null,
    cpCode varchar(20) not null,
    content varchar(500) not null,
    isGot bit not null
)

//另一种自增加主键
create table PLUS_SMS
(
    s_id int IDENTITY(1,1),
    beginTime DateTime not null,
    endTime DateTime not null,
    senderCode varchar(20) not null,
    cpCode varchar(20) not null,
    content varchar(500) not null,
    isGot bit not null,
    constraint pk_plus_sms primary key(userId)
)

//双主键
CREATE TABLE CommonCode_table
(
   codeType varchar(20) not null,  /*代码类型*/
   codeName varchar(20) not null,  /*代码名称*/
   codeValue varchar(100) not null,  /*代码值*/
   constraint pk_commoncode primary key(codeType, codeName)
)

//外键1
create table PLUS_NUMBER
(
  n_id int identity(1,1),
  number varchar(20) not null,
  s_id int not null,
  constraint pk_plus_number primary key(n_id),
  constraint fk_plus_sid foreign key(s_id)

 references PLUS_SMS(s_id)
)
//外键2
create table PLUS_NUMBER
(
  n_id int identity(1,1) Primary Key,
  number varchar(20) not null,
  s_id int not null foreign key references PLUS_SMS(s_id),
)

//CHECK约束
create table Users
(
UserID varchar(15) not null Primary Key, //主键
UserPassword varchar(30) not null, //varchar与char相比,char不满时会用空格填充,varchar则不会
Role varchar(25) not null constraint checkrole CHECK (Role in ('Saler', 'Administrator','SuperAdministrator'))
//CHECK约束
)