
复制create database temp go use temp go create table UserInfo ( UserId int identity(1,联删1) primary key , UserName varchar(20), --用户名 password varchar(20) not null --密码 ) create table UserDetails ( id int identity(1,1) primary key, name varchar(50) not null, --真实姓名 userId int, foreign key (userId) references UserInfo(UserId) on delete cascade 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.