示例1.sql

SQL基础教程上的一些源码

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));