标准 sql 建立数据库方案
use master
go
go
如果已经存在 Eclipsdbmanager 数据库则先删除该数据库
if exists(select name from sysdatabases where name='Eclipsdbmanager')
drop database Eclipsdbmanager
go
if exists(select name from sysdatabases where name='Eclipsdbmanager')
drop database Eclipsdbmanager
go
创建数据库 Eclipsdbmanager
create database Eclipsdbmanager
go
create database Eclipsdbmanager
go
use Eclipsdbmanager
go
go
创建表
create table employees(
userId varchar(20) not null primary key,
userName varchar(10),
password varchar(10),
name varchar(30),
phone varchar(20),
email varchar(30),
deptId int,
roleId int,
)
go
create table employees(
userId varchar(20) not null primary key,
userName varchar(10),
password varchar(10),
name varchar(30),
phone varchar(20),
email varchar(30),
deptId int,
roleId int,
)
go
create table roles(
roleId int primary key identity(1,1),
KeyWord varchar(20),
roleName varchar(20)
)
go
roleId int primary key identity(1,1),
KeyWord varchar(20),
roleName varchar(20)
)
go
创建表关系 外键约束
alter table employees
add constraint FK_DEPTID
foreign key (roleId)
references roles(roleId)
go
alter table employees
add constraint FK_DEPTID
foreign key (roleId)
references roles(roleId)
go
相关热门文章
给主人留下些什么吧!~~
评论热议