informix 约束检查

lawever

--查询 表 tbl_demo 引用的表SELECTa.tabname, constrname, d.tabname FROMsystables a, sysconstraints b, sysreferences C, systables d WHEREb.constrtype = 'R' ANDa.tabid = b.tabid ANDb.constrid = C.constrid ANDC.ptabid = d.tabid ANDd.tabname = ' tbl_demo';--查询引用了 tbl_demo 的表SELECTa.tabname, constrname, d.tabname FROMsystables a, sysconstraints b, sysreferences C, systables d WHEREb.constrtype = 'R' ANDa.tabid = b.tabid ANDb.constrid = C.constrid ANDC.ptabid = d.tabid ANDd.tabname = ' tbl_demo';