
复制createdatabasetemp go use temp go createtable UserInfo ( UserId int identity(1,数据1) primarykey , UserName varchar(20), --用户名 passwordvarchar(20) notnull--密码 ) createtable UserDetails ( id int identity(1,1) primarykey, namevarchar(50) notnull, --真实姓名 userId int, foreignkey (userId) references UserInfo(UserId) ondeletecascade ) insert UserInfo values (ly,jeff) insert UserInfo values(wzq,wzqwzq) insert UserInfo values(lg,lglg) insert UserDetails values(李四,1) insert UserDetails values(王五,2) insert UserDetails values(刘六,3) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.