级联删除功能

(1) 在sql2005中，如何获取表的外键？

(2)目前的删除功能有一个BUG，在DAO层中，返回了DataTable。需修改。

 

 

 

取外键的相关sql:

SELECT sysobjects.id objectId,
OBJECT_NAME(sysobjects.parent_obj) tableName,
sysobjects.name constraintName,
sysobjects.xtype AS constraintType,
syscolumns.name AS columnName,
syscolumns.*
FROM sysobjects inner JOIN sysconstraints
ON sysobjects.xtype in('C', 'F', 'PK', 'UQ', 'D')
 AND sysobjects.id = sysconstraints.constid
LEFT OUTER JOIN syscolumns ON sysconstraints.id = syscolumns.id
WHERE OBJECT_NAME(sysobjects.parent_obj)='DEMO_DETAIL' and syscolumns.typestat='0'

select * from sysobjects where id='743673697'
select * from sysconstraints
select * from syscolumns where [name] like 'detail%'