CREATE SCHEMA AUTHORIZATION LIMING
go
CREATE TABLE Student5
(Sno char(9)PRIMARY KEY,
Sname char(20)UNIQUE,
Ssex char(2),
Sage smallint,
Sdept char(20)
);
CREATE TABLE Course5
(Cno char(4) PRIMARY KEY,
Cname char(40),
Cpno char(4),
Ccredit smallint,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);
CREATE TABLE SC1
(Sno char(9),
Cno char(4),
Grade smallint,
PRIMARY KEY (Sno,Cno),
FOREIGN KEY (Sno) REFERENCES Student(Sno),
FOREIGN KEY (Cno) REFERENCES Course(Cno),
);
在SQL中执行完后责那么没有显示出表,那该怎么建具体的表?显示出来
go
CREATE TABLE Student5
(Sno char(9)PRIMARY KEY,
Sname char(20)UNIQUE,
Ssex char(2),
Sage smallint,
Sdept char(20)
);
CREATE TABLE Course5
(Cno char(4) PRIMARY KEY,
Cname char(40),
Cpno char(4),
Ccredit smallint,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);
CREATE TABLE SC1
(Sno char(9),
Cno char(4),
Grade smallint,
PRIMARY KEY (Sno,Cno),
FOREIGN KEY (Sno) REFERENCES Student(Sno),
FOREIGN KEY (Cno) REFERENCES Course(Cno),
);
在SQL中执行完后责那么没有显示出表,那该怎么建具体的表?显示出来
错了,select * from SCHEMANAME.Student5
SELECT SCHEMA_NAME();