查整个数据库中哪些表用这个字段
SELECT TABLE_NAME,COLUMN_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='列名(大写)'
顺便查看备注信息:
SELECT col.TABLE_NAME,col.COLUMN_NAME,comm.comments FROM USER_TAB_COLUMNS col,user_col_comments comm
WHERE col.COLUMN_NAME = comm.column_name and col.TABLE_NAME = comm.table_name and col.COLUMN_NAME='列名(大写)'