USER_CONS_COLUMNS - Oracle Schema 관련 쿼리

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 -