單項(xiàng)選擇題

您在公司的數(shù)據(jù)庫(kù)中成功創(chuàng)建了名為SALARY的表。您現(xiàn)在要通過(guò)向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY約束條件來(lái)建立EMPLOYEES表與SALARY表之間的父/子關(guān)系。尚未向SALARY表添加任何數(shù)據(jù)。應(yīng)執(zhí)行以下哪條語(yǔ)句()

A.ALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY(employee_id)REFERENCES employees(employee_id)
B.ALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary(employee_id)AND employees(employee_id)
C.ALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees(employee_id)
D.ALTER TABLE salary ADD CONSTRAINT fk_employee_id_FOREIGN KEY salary(employee_id)=employees(employee_id)

微信掃碼免費(fèi)搜題