示例1.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 19 行

CREATE DATABASE S_C_SC
GO
USE S_C_SC
GO
CREATE TABLE student(
    sno  INT PRIMARY KEY,
    sname CHAR(10));     
    
CREATE TABLE sc(
    sno  INT,
    cno  INT,
    grade  FLOAT,
   PRIMARY KEY(sno,cno));

CREATE TABLE sc(
    sno  INT REFERENCES student(sno),
    cno  INT,
    grade  FLOAT,
   PRIMARY KEY(sno,cno));