Sybse数据库管理工具,查看表之间的依赖关系
1.选中表,邮件点击,在弹出窗口选中show in window。操作界面如下:
2.选中show in window弹框如下:点击References即可查看表之间的依赖关系,从而在删除数据时,先删除从表数据,然后在删主表。如果直接删除主表会报违反了数据完整性的错误。
3.还可以查询主表与从表通过哪些字段作为主键和外键相互关联的。在右侧复选框中选中Show One Link/Column。然后在Bode Conten下拉列表中选择Column,则出现右侧图示,从图中可以看到主表和从表通过哪些字段关联。操作步骤如图所示:
从中可以看到WR_WORKITEM_CONTEX表,WR_APPLICATION表是WR_WORKITEM的从表。而WR_WORKITEM表,WR_ACTIVITY_CONTEXT表是WR_ACTIVITY的从表,所以再删除数据时,为了维护数据的完整性。删除顺序如下:
delete from WR_APPLICATION where WORKITEMID in(select id from wr_WorkItem where name='总裁' and procinstid ='173055') and ACTINSTID in(select ACTINSTID from wr_WorkItem where name='总裁' and procinstid ='173055');
delete from WR_WORKITEM_CONTEXT where PARENTID in(select id from wr_WorkItem where name='总裁' and procinstid ='173055');
delete from wr_WorkItem where name='总裁' and procinstid ='173055';
delete from WR_ACTIVITY_CONTEXT where PARENTID in(select ACTINSTID from wr_WorkItem where name='总裁' and procinstid ='173055');
delete from wr_activity where name='总裁' and PROCINSTID ='173055';