Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview
PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.
Download the book in PDF, ePub, Kindle for a complete version.
→ NEXT
10.04 How to delete the column?
Assumption has been made that no data exists in the "to be deleted column",
DROP table column test-col2 in test-table
Through obJect Browser
Through sql command
Window
→ Tables
→ TEST_TABLE
→ DROP Column
alter table testtable drop column test-col2