SELECT * FROM USER_CONS_COLUMNS WHERE CONSTRAINT_NAME LIKE 'XPK%' ORDER BY TABLE_NAME SELECT * FROM USER_CONS_COLUMNS WHERE TABLE_NAME LIKE 'TAB%' ORDER BY TABLE_NAME SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME LIKE 'TAB%' ORDER BY TABLE_NAME - write by 꼬마갱이 2009.12.11 -