ALTER TABLE cardInfo
ADD CONSTRAINT PK_cardID PRIMARY KEY(cardID),
CONSTRAINT CK_cardID CHECK(cardID like'1010 3576 [0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9]') ,
CONSTRAINT DF_curType DEFAULT('RMB')
FOR curType,
CONSTRAINT CK_savingType check(saving='活期'or saving='定期') ,
CONSTRAINT DF_openDate DEFAULT (getdate()) for openDate,
CONSTRAINT CK_openMoney check(openMoney>=1) ,
CONSTRAINT CK_balance check(balance>=1) ,
CONSTRAINT CK_pass CHECK(len(pass)>=6) ,
CONSTRAINT DF_pass DEFAULT (888888),
CONSTRAINT DF_IsReportLoss DEFAULT(0)
错误提示 消息 142,级别 15,状态 2,第 0 行
约束 'TABLE' 的定义中有语法错误。
ADD CONSTRAINT PK_cardID PRIMARY KEY(cardID),
CONSTRAINT CK_cardID CHECK(cardID like'1010 3576 [0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9]') ,
CONSTRAINT DF_curType DEFAULT('RMB')
FOR curType,
CONSTRAINT CK_savingType check(saving='活期'or saving='定期') ,
CONSTRAINT DF_openDate DEFAULT (getdate()) for openDate,
CONSTRAINT CK_openMoney check(openMoney>=1) ,
CONSTRAINT CK_balance check(balance>=1) ,
CONSTRAINT CK_pass CHECK(len(pass)>=6) ,
CONSTRAINT DF_pass DEFAULT (888888),
CONSTRAINT DF_IsReportLoss DEFAULT(0)
错误提示 消息 142,级别 15,状态 2,第 0 行
约束 'TABLE' 的定义中有语法错误。
ALTER TABLE cardInfo
ADD CONSTRAINT PK_cardID PRIMARY KEY(cardID)
ALTER TABLE cardInfo
CONSTRAINT CK_cardID CHECK(cardID like'1010 3576 [0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9]')
ALTER TABLE cardInfo
CONSTRAINT DF_curType DEFAULT('RMB')
FOR curType
ALTER TABLE cardInfo
CONSTRAINT CK_savingType check(saving='活期'or saving='定期')
ALTER TABLE cardInfo
CONSTRAINT DF_openDate DEFAULT (getdate()) for openDate
ALTER TABLE cardInfo
CONSTRAINT CK_openMoney check(openMoney>=1)
ALTER TABLE cardInfo
CONSTRAINT CK_balance check(balance>=1)
ALTER TABLE cardInfo
CONSTRAINT CK_pass CHECK(len(pass)>=6)
ALTER TABLE cardInfo
CONSTRAINT DF_pass DEFAULT (888888)
ALTER TABLE cardInfo
开始要有表名
CONSTRAINT DF_IsReportLoss DEFAULT(0)
分开写
ALTER TABLE cardInfo
add CONSTRAINT PK_cardID PRIMARY KEY(cardID)
ALTER TABLE cardInfo
add CONSTRAINT DF_curType DEFAULT('RMB')
FOR curType...
CONSTRAINT CK_cardID CHECK(cardID like'1010 3576 [0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9]') ,
CONSTRAINT DF_curType DEFAULT('RMB') FOR curType,
CONSTRAINT CK_savingType check(saving='活期'or saving='定期'),
CONSTRAINT DF_openDate DEFAULT (getdate()) for openDate,
CONSTRAINT CK_openMoney check(openMoney>=1) ,
CONSTRAINT CK_balance check(balance>=1) ,
CONSTRAINT CK_pass CHECK(len(pass)>=6) ,
CONSTRAINT DF_pass DEFAULT (888888) for 字段,
CONSTRAINT DF_IsReportLoss DEFAULT(0) for 字段