1、建库
if exists(select * from sysobjects where name= emp)
drop database temp
go
create database temp
go
use temp
go
--主表
use temp
if exists(select * from sysobjects where name=UserInfo)
drop table UserInfo
go
create table UserInfo
(
UserId int identity(1,1) primary key ,
UserName varchar(20), --用户名
password varchar(20) not null --密码
)
--子表
if exists(select * from sysobjects where name=UserDetails)
drop table UserDetails
go
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
)
go
--2、添加数据
insert UserInfo values (ly,jeff)