SELECT TABLE_NAME, CONSTRAINT_NAME
FROM USER_CONSTRAINTS
WHERE TABLE_NAME IN('테이블명1','테이블명2');
column TABLE_NAME format a15
column COLUMN_NAME format a15
column CONSTRAINT_NAME format a15
SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME
FROM USER_CONS_COLUMNS
WHERE TABLE_NAME='BBS';