chapter1_ibmdb2_solution2_changes.txt

来自「SQL Server入门经典源码」· 文本 代码 · 共 18 行

DROP TABLE Attendance;
CREATE TABLE Attendance
(
    MeetingDate date,
    LocationId integer,
    MemberAttended char(1),
    MemberId integer
);

CREATE TABLE Location
(
    LocationId integer,
    Street varchar(100),
    City varchar(75),
    State varchar(75)
);