chapter1_ms_access_solution2_modifydb.txt

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

ALTER TABLE Attendance
  DROP COLUMN Location;

ALTER TABLE Attendance
  ADD LocationId integer;

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