记下来备用:
添加外键:
CREATE TABLE UserInfo
(
UserId INT NOT NULL PRIMARY KEY,
[Password] NVARCHAR(20) NOT NULL,
[UserName] NVARCHAR(20) NOT NULL
)
CREATE TABLE Friends
(
MainId INT NOT NULL,
SubId INT NOT NULL
)
ALTER TABLE Friends ADD CONSTRAINT PK_Friends_MainId_UserInfo_Userid FOREIGN KEY(MainId) REFERENCES UserInfo(UserId)
ALTER TABLE Friends ADD CONSTRAINT PK_Friends_SubId_UserInfo_Userid FOREIGN KEY(SubId) REFERENCES UserInfo(UserId)
添加字段:
ALTER TABLE Friends ADD testmemo varchar(200) NULL