Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

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.

→ 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