Skip to content

oracle drop column

Jump to bottom
ghdrako edited this page Sep 27, 2023 · 1 revision 
ALTER TABLE JOBS_TEMP SET UNUSED (DUMMY1, DUMMY2)

SELECT * FROM USER_UNUSED_COL_TABS WHERE TABLE_NAME='JOBS_TEMP'

ALTER TABLE JOBS_TEMP DROP UNUSED COLUMNS

Test

Clone this wiki locally