高斯数据库删除表数据，有约束条件提示太不明确，根本不提示哪张表约束限制了。如下图文
SQL 错误 [1223] [28000]: [errorCode=GS-01223, SQLState=‘28000’, reason=‘errLine = 0, errColumn = 0, errMsg=Integrity constraint violated - child record found,ioClient:@746e0782’, sql=delete from gwlzxx where chrlzlx in (‘001’,‘002’) and dtmdjsj<sysdate+5, sessionId=66, serverIP=192.168.0.156:1888, clientIP=192.168.63.1.]
[errorCode=GS-01223, SQLState=‘28000’, reason=‘errLine = 0, errColumn = 0, errMsg=Integrity constraint violated - child record found,ioClient:@746e0782’, sql=delete from gwlzxx where chrlzlx in (‘001’,‘002’) and dtmdjsj<sysdate+5, sessionId=66, serverIP=192.168.0.156:1888, clientIP=192.168.63.1.]
[errorCode=GS-01223, SQLState=‘28000’, reason=‘errLine = 0, errColumn = 0, errMsg=Integrity constraint violated - child record found,ioClient:@746e0782’, sql=delete from gwlzxx where chrlzlx in (‘001’,‘002’) and dtmdjsj<sysdate+5, sessionId=66, serverIP=192.168.0.156:1888, clientIP=192.168.63.1.]
删除表约束提示不清楚，就把该表的主键，把所有的表找出来，通过一个小技巧sql：本来想通过表行数清理，但是数据字段表行数全部未空，就用的bytes字段，这样可以过滤一些空表。
SELECT ut.TABLE_NAME,ut.BYTES,COL.column_name FROM user_tables ut,USER_TAB_COLS col WHERE ut.table_name =col.table_name
AND col.column_name=‘INTGWLZLSH’ ORDER BY ut.BYTES DESC
把含有该字段的表全部清理出来，一张一张删掉。
SELECT 'select * from ‘||ut.TABLE_NAME||’; ’ FROM user_tables ut,USER_TAB_COLS col WHERE ut.table_name =col.table_name
AND col.column_name=‘INTGWLZLSH’ ORDER BY ut.BYTES DESC
SELECT 'delete from ‘||ut.TABLE_NAME||’; ’ FROM user_tables ut,USER_TAB_COLS col WHERE ut.table_name =col.table_name
AND col.column_name=‘INTGWLZLSH’ ORDER BY ut.BYTES DESC
