select * –\ud14c\uc774\ube14\uc815\ubcf4
\nfrom all_tables
\nwhere tablE_name = ‘TB_M30_PRD_RSL’
\n;<\/p>\n
select * — \uceec\ub7fc\uc815\ubcf4
\nfrom all_tab_columns
\nwhere tablE_name = ‘TB_M30_PRD_RSL’
\n;<\/p>\n
select * — \uceec\ub7fc\ucf54\uba58\ud2b8
\nfrom all_COL_COMMENTS
\nwhere tablE_name = ‘TB_M30_PRD_RSL’
\n;<\/p>\n
select * — \ud14c\uc774\ube14\ucf54\uba58\ud2b8
\nfrom all_TAB_COMMENTS
\nwhere tablE_name = ‘TB_M30_PRD_RSL’
\n;<\/p>\n
SELECT *
\nFROM all_constraints cons
\nWHERE CONSTRAINT_TYPE = ‘P’
\n;<\/p>\n
SELECT — \ud14c\uc774\ube14\uc758 PK\uceec\ub7fc
\n cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
\nFROM all_constraints cons, all_cons_columns cols
\nWHERE cons.constraint_type = ‘P’
\nAND cons.constraint_name = cols.constraint_name
\nAND CONS.TABLE_NAME = ‘TB_M30_PRD_RSL’
\nORDER BY cols.table_name, cols.position
\n;<\/p>\n","protected":false},"excerpt":{"rendered":"
select * –\ud14c\uc774\ube14\uc815\ubcf4 from all_tables where tablE_name = ‘TB_M30_PRD_RSL’ ; select * — \uceec\ub7fc\uc815\ubcf4 from all_tab_columns where tablE_name = ‘TB_M30_PRD_RSL’ ; select * — \uceec\ub7fc\ucf54\uba58\ud2b8 from all_COL_COMMENTS where tablE_name = ‘TB_M30_PRD_RSL’ ; select * — \ud14c\uc774\ube14\ucf54\uba58\ud2b8 from all_TAB_COMMENTS where tablE_name = ‘TB_M30_PRD_RSL’ ; SELECT * FROM all_constraints cons WHERE CONSTRAINT_TYPE = ‘P’ ; SELECT — … Continue reading \uc624\ub77c\ud074 \ud14c\uc774\ube14 \uc815\ubcf4 \uac00\uc838\uc624\uae30<\/span>