2017数学三级数大题-2017年计算机三级数据库辅导：SQLServer2000级联删除的问题列举

create table client(   c_id int identity(1,1),  
 c_name nvarchar(255) unique, 
  c_pass nvarchar(255),  
 c_sex bit,   c_mail varchar(255),  
 c_qq varchar(255),   primary key(c_id)   );   
create table album_kind(   k_id int identity(1,1),  
 k_name nvarchar(255),   k_desc nvarchar(255),  
 primary key(k_id)   );  
 create table album(   a_id int identity(1,1),  
 a_name nvarchar(255),   
a_desc nvarchar(255),  
 a_create_date datetime,  
 a_times bigint,  
 c_id int,   k_id int,   
primary key(a_id),   
foreign key(c_id) references 
client(c_id) on delete cascade,   
foreign key(k_id) references
 album_kind(k_id) on delete cascade   );  
 create table album_word(
   aw_id int identity(1,1),  
 aw_title nvarchar(255),   
aw_content nvarchar(500),  
 commit_date datetime,   a_id int,  
 c_id int,   primary key(aw_id),  
 foreign key(a_id) references album(a_id) on delete cascade,  
 foreign key(c_id) references client(c_id) on delete cascade   );

本文来源：https://www.wddqw.com/TnDO.html