查人人中国名人网昆明航空招飞:简单的SQL语句，可是提示出错
来源：百度文库 编辑：查人人中国名人网 时间：2024/04/29 23:57:39
create table city
(
cityID int primary key,
proID int foreign key references province proID,
cityName varchar(20) not null
)
(
cityID int primary key,
proID int foreign key references province proID,
cityName varchar(20) not null
)
CREATE TABLE E_15 (
abc char(18) NOT NULL,
aaa char(18) NULL,
bbb char(18) NULL,
ccc char(18) NULL,
code int NOT NULL
)
go
ALTER TABLE E_15
ADD PRIMARY KEY (abc, code)
go
CREATE TABLE join (
code int NOT NULL,
iscode nvarchar(50) NULL,
name nvarchar(50) NULL
)
go
ALTER TABLE join
ADD PRIMARY KEY (code)
go
ALTER TABLE E_15
ADD FOREIGN KEY (code)
REFERENCES join
go
SQL语句太久没写了,这是用ERWIN生成的代码,你去执行一下,就明白了.
主键和外键需要单独create