?? chapter4_ms_sql_access_db_alterations.txt
字號:
ALTER TABLE Location
ALTER COLUMN LocationId int NOT NULL;
ALTER TABLE Location
ADD CONSTRAINT locationid_pk PRIMARY KEY (LocationId);
ALTER TABLE Attendance
ADD CONSTRAINT locationid_fk
FOREIGN KEY (LocationId)
REFERENCES Location(LocationId);
DELETE FROM Attendance
WHERE MemberAttended = 'N';
ALTER TABLE MemberDetails
ALTER COLUMN MemberId int NOT NULL;
ALTER TABLE MemberDetails
ADD CONSTRAINT memberdetails_pk PRIMARY KEY (MemberId);
ALTER TABLE Films
ALTER COLUMN FilmId int NOT NULL;
UPDATE Films
SET FilmId = 13
WHERE FilmId = 12 AND
FilmName = 'The Good, the Bad, and the Facially Challenged';
UPDATE Films
SET FilmId = 14
WHERE FilmId = 2 AND
FilmName = '15th Late Afternoon';
UPDATE Films
SET FilmId = 15
WHERE FilmId = 2 AND
FilmName = 'Soylent Yellow';
ALTER TABLE Films
ADD CONSTRAINT films_pk PRIMARY KEY (FilmId);
ALTER TABLE Category
ALTER COLUMN CategoryId int NOT NULL;
ALTER TABLE Category
ADD CONSTRAINT category_pk PRIMARY KEY (CategoryId);
ALTER TABLE FavCategory
ALTER COLUMN CategoryId int NOT NULL;
ALTER TABLE FavCategory
ALTER COLUMN MemberId int NOT NULL;
ALTER TABLE FavCategory
ADD CONSTRAINT favcategory_pk PRIMARY KEY (CategoryId, MemberId);
ALTER TABLE MemberDetails
ALTER COLUMN FirstName varchar(50) NOT NULL;
ALTER TABLE MemberDetails
ALTER COLUMN LastName varchar(50) NOT NULL;
CREATE UNIQUE INDEX member_name_indx
ON MemberDetails (LastName DESC, FirstName);
ALTER TABLE Attendance
ADD CONSTRAINT attend_loc_fk
FOREIGN KEY (LocationId)
REFERENCES Location(LocationId);
ALTER TABLE Attendance
ADD CONSTRAINT attend_memdet_fk
FOREIGN KEY (MemberId)
REFERENCES MemberDetails(MemberId);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -